This content has been marked as final. Show 3 replies
Whenever you post provide your full sql developer version (and don't just say 'latest version').1 person found this helpful
My sql developer client has a default setting of compilng PL/SQL code with optimization level = 0 , while our database has a default = 2.
When modifying this level and setting it to 0, the debug flag is turned on, although not specified in the sql developer client)
You said it was already 0 so how are you modifying it? Where are you modifying it?
My client and db settings are the same as your defaults and in 3.2.20.09 I change the value in sql dev from 0 to 2 and nothing happens to those quer results. And I can change it back to 0 and nothing happens. DB still says debug is off.
I have a connection open when I tested. Do you have any other windows open?
My sql developer Version is 3.2.20.09.
I also have sqldeveloper version 3.2.20.09 and look up the value for optimizer in the preferences menu via preferences -> database -> PL/SQL (just as in my first message)
BTW I can still reproduce this issue (and 15 other dbas and developers at where I work) on both oracle 10 and 11.
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
"CORE 10.2.0.4.0 Production"
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production
PL/SQL Release 220.127.116.11.0 - Production
"CORE 18.104.22.168.0 Production"
TNS for Linux: Version 22.214.171.124.0 - Production
NLSRTL Version 126.96.36.199.0 - Production
BTW We've been using sqldeveloper here since version 2.x. We found a workaround by setting the value for Optimization Level to 2, although you might not reproduce the issue, I suggest to keep it for others, although it seems not many others experience this issue.