Re: 4031 - errors

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 3 Jun 2004 13:48:31 +0100

Jared wrote
> 3)  The other choke, gasp, dba had alot of dbms_outputs in procedure,

> functions except that he moved into production instead of commenting

> 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.

There is a complete example of this in Mastering PL/SQL - I believe
that the code is even available for download if you don't have the
book, which you should.

Niall Litchfield
Oracle DBA
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: