Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql developer generating case-sensitive object names

EdStevensNov 14 2012 — edited Nov 14 2012
Oracle 11.2.0.1
Oracle Linux 5.6 x86-64
--
SQL Developer 3.2.20.09
Win 7 Pro 32-bit
--
Just downloaded and installed latest SQL Developer, specifically to experiment with the job scheduler wizard. At first blush it appeared to give the easy user interface I want for my developers, but on closer inspection I noticed that when it generates the sql to call dbms_scheduler, it encloses the user provided job name in double-quotes. Thus, the job names get created in the data dictionary with case-sensitivity. We all know what THAT means! A quick run through the config options didn't turn up anything I recognized as an adjustment to this behavior. Telling the developers "always enter your job name in all caps, or I'll slap your hand with a ruler" isn't really an acceptable alternative.

Ideas?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2012
Added on Nov 14 2012
1 comment
380 views