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!

How to set that procedure will not be Compiled for debug by default?

Blue BirdJan 23 2019 — edited Jan 24 2019

Hi,

I have a problem in SQLDev. Since SQLDev 18.3 I'm noticing that when I create new procedures or functions (on remote Oracle 12 server) that are not compiled as Release version as it was always before. Till version 18.2 worked Ok, but on 18.3 and also now on 18.4 this doesn't work any more that way. If I create procedure for example from SQLPlus or SQLcl everything compile normally (as release and not for debugging). Also if I create procedure with SQLDev locally on that server also work fine. So actually I see this when I run procedures from different versions of SQLDev:

pastedImage_0.png

But I shouldn't see any green icons. So if I run script with dozen of existing procedures I have to compile each "one by one" as Release version.

Is this a bug in this newer versions of SQLDev or do I have to change some settings so my procedures will be compiled as release (locally or on the server). Also compile button on the toolbar:

pastedImage_1.png

behave differently. Before when I directly click on it, it was compiled as Release, now is default Compiled for debug. So if I want to compile procedure I have to click arrow on right side of the gear and select Compile.

1. Can someone of you confirm that same behaviour of SQLDev? If not, why is this happening on my system?

2. How can I run SQLDev from scratch as clean first start without using any previous settings? Can I for example move folder with settings from 18.4 on location "c:\Users\UserName\AppData\Roaming\SQL Developer\" into some other folder just to check if then work Ok, and later move it back so I wont lost all my connections and customization settings?

3. Exist in SQLDev some command where can I export all setting including connections and then restore it back if I want to?

4. Can I somehow compile all my procedures as Release version at once? Right click > Compile all... compile all but doesn't change Debug version into Release version.

Thanks for your help.

BB

This post has been answered by John McGinnis-Oracle on Jan 23 2019
Jump to Answer

Comments

Post Details

Added on Jan 23 2019
4 comments
1,299 views