4031 - errors 2004-06-02 - By Jared.Still@(protected)
oracle-l-bounce@(protected) wrote on 06/02/2004 02:03:38 PM:
> OK - here are some things that contributed to my problems and woes:
>
> 3) The other choke, gasp, dba had alot of dbms_outputs in procedure,
> functions except that he moved into production instead of commenting
them
> out.
Commenting them out is bad form for production code. A switch that can
be set at runtime to enable/disable the debug code is quite a bit better.
The default of course should be false.
Jared
> one procedure that called another function which called another
> function, had more than 20 of these things. And yes same person who is
> updating
> across the links.....
>
Many functions is better than 1 big one. You just need to implement
a trace mechanism to trace the call stack when the, *ahem*, debug
flag is set.
Jared
<br > <font size=2 > <tt >oracle-l-bounce@(protected) wrote on 06/02/2004
02:03:38 PM: <br >
<br >
> OK - here are some things that contributed to my problems and woes: <br >
> <br >
> 3) The other choke, gasp, dba had alot of dbms_outputs in procedure, <br >
> functions except that he moved into production instead of commenting
them <br >
> out. <br >
</tt > </font >
<br > <font size=2 > <tt >Commenting them out is bad form for production code.
A switch that can </tt > </font >
<br > <font size=2 > <tt >be set at runtime to enable/disable the debug code
is quite a bit better. </tt > </font >
<br >
<br > <font size=2 > <tt >The default of course should be false. </tt > </font >
<br >
<br > <font size=2 > <tt >Jared </tt > </font >
<br >
<br >
<br > <font size=2 > <tt >> one procedure that called
another function which called another <br >
> function, had more than 20 of these things. And yes same person
who is <br >
> updating <br >
> across the links..... <br >
> <br >
</tt > </font >
<br > <font size=2 > <tt >Many functions is better than 1 big one. You
just need to implement </tt > </font >
<br > <font size=2 > <tt >a trace mechanism to trace the call stack when the,
*ahem*, debug </tt > </font >
<br > <font size=2 > <tt >flag is set. </tt > </font >
<br >
<br > <font size=2 > <tt >Jared </tt > </font >
<br >
|
|
