Forum Stats

  • 3,817,445 Users
  • 2,259,334 Discussions
  • 7,893,776 Comments

Discussions

how to test whether a procedure is recompiled or not

GaryBao
GaryBao Member Posts: 48
edited Jul 29, 2009 12:09AM in SQL & PL/SQL
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
Tagged:

Answers

This discussion has been closed.