Turning off debugger

[Lisa Boike]

We have the option checked that does not automatically turn on debugger with compile. We turn it on manually, usually without recompiling first. After debugging, we have been asked by our DBA to turn off debugger. When I try to uncheck the option it does not turn it off. The only way I can find to turn it off is compiling. Most of the time we do not want to do that. Is there a way to uncheck debug without recompiling?

Thanks.
Lisa

 

[Marco Kalter]

When this option is enabled, PL/SQL Developer will compile program units while the debug option is set for the session. The only way to remove the debug information is through a script that recompiles these program units when the debug option is not applied. For example:

alter session set plsql_debug=false;
alter procedure abc compile;
alter procedure def compile;
...

 

[William Robertson]

You can recompile affected objects with something like this:

begin
    for r in (
        select distinct 'alter '||replace(ps.type,' BODY')||' '||ps.name||' compile' as compile_cmd
        from   user_plsql_object_settings ps
        where  ps.plsql_debug = 'TRUE'
    )
    loop
        execute immediate r.compile_cmd;
    end loop;
end;
/

You could even save that as a script and add it as a menu bar tool (Configure > Tools, set type to 'Session').

Out of interest, why would the DBA care what debug settings you use in dev/test environments?