What would be the effect on the two procedures if the value of debug is set to false?

C D

C, D

Database PL/SQL User’s Guide and Reference:

“Changing the value of one of the constants forces all the dependent units of the package to recompile with the new value.”

Changing the value of one of the constants forces all the dependent units of the package
to recompile with the new value.
For example, changing the value of debug to FALSE would cause my_proc1
to be recompiled without the debugging code.
my_proc2 would also be recompiled,
but my_proc2 would be unchanged because the value of trace did not change.

C, D

11 R1
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/fundamentals.htm#CIHEBFHF

11 R2
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/fundamentals.htm#CIHEBFHF

create or replace package my_debug is
debug CONSTANT BOOLEAN := FALSE;
trace CONSTANT BOOLEAN := TRUE;
end my_debug;
/

create procedure my_proc1 is
BEGIN
$if my_debug.debug $then
dbms_output.put_line(‘Debuging on’);
$else
dbms_output.put_line(‘Debuging off’);
$end
end my_proc1;
/

create procedure my_proc2 is
BEGIN
$if my_debug.trace $then
dbms_output.put_line(‘TRACING on’);
$else
dbms_output.put_line(‘TRACING off’);
$end
end my_proc2;

Here are several of the internet sites we recommend for our visitors.

Here are some of the sites we advocate for our visitors

just beneath, are various completely not connected web sites to ours, however, they may be certainly worth going over

Very few web sites that come about to be detailed below, from our point of view are undoubtedly properly worth checking out.

just beneath, are quite a few entirely not related sites to ours, having said that, they are certainly really worth going over

that would be the finish of this report. Here youll find some websites that we consider you will enjoy, just click the links over

??