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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------