Skip to Main Content

SQL & PL/SQL

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 test whether a procedure is recompiled or not

GaryBaoJul 28 2009 — edited Jul 29 2009
create paceage my_debug is
debug constant boolean := true;
trace constant boolean := true;
end my_debug;
/

create procedure my_proc is
begin
if my_debug.debug then
dbms_output.put_line('Debugging ON');
else dbms_output.put_line('Debugging OFF');
end if;
end my_proc;
/

the manual said: if changing the value of debug to FALSE would cause my_proc to be recompiled without the debugging code. I hv two questions:
1, what does 'without the debugging code' mean?
2, how can I test whether my_proc is recompiled or not?

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2009
Added on Jul 28 2009
4 comments
460 views