how to test whether a procedure is recompiled or not

GaryBao

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

SanjayRs

>

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:

Which manual are you referring ?

SS

GaryBao

pl_sql user's guide and reference

SanjayRs

OK .

If you have your debug code in the procedure, it will still be compiled but when executing it will not execute or execute depending on the variable set.

Instead use Sql developer to debug code, available for free. [Sql Developer|http://www.oracle.com/technology/products/database/sql_developer/index.html]

SS

GaryBao

when we changed the packeage and compiled it. we dont need to compile the procedure, it will be compiled automatically, right?