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?
