Re: Redirecting output from DBMS

From: Pete Finnigan <pete_at_petefinnigan.com>
Date: Mon, 15 Sep 2003 14:34:00 +0100
Message-ID: <9MujZPBI$bZ$EwaX@peterfinnigan.demon.co.uk>

It is not possible to get them back. Use either the utl_file package and write your output to a log file or create a logging table and write your messages to a table instead. You may benefit by using the autonomous transaction syntax in the latter case so the logging row doesn't get rolled back.

kind regards

pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

Received on Mon Sep 15 2003 - 08:34:00 CDT

Re: Redirecting output from DBMS_OUTPUT