Re: Printing debug statements in stored procedure/packages

We used the DBMS_PIPE package to send logging/debug info from a package to another session that continually retrieved the messages and inserted them into a table. This design sent all log/debug messages out of the current COMMIT/ROLLBACK scope. After they were inserted and committed by the receiver they were visible regardless of the outcome of the originating transaction.

This worked well since we were writing server based daemons and wanted to record informative processing info but didn't have a user to view it. We did run into some situations where the pipe would overflow and some messages would be lost.

Dave Podnar
NCR Corp.
dave.podnar_at_daytonoh.ncr.com
>==========Joe Vivona, 3/9/96==========
>
>For stored procedures or PL/SQL look at using the DBMS_OUTPUT
>package that comes with Oracle (See the Application Developer's
>Guide for more info).
>
>--
>Joe Vivona, Owner
>A&J Computers
>(908) 815-1525
Received on Tue Mar 12 1996 - 00:00:00 CET