Re: 4031 - errors

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 3 Jun 2004 13:48:31 +0100
Message-ID: <7765c89704060305487d107a8d@mail.gmail.com>

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

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
http://www.niall.litchfield.dial.pipex.com

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 03 2004 - 07:45:20 CDT