Re: PL/SQL and output

From: Jaap W. van Dijk <j.w.vandijk_at_ptt-telecom.nl>
Date: 1998/03/20
Message-ID: <6etoqn$n71$1@hdxf08.telecom.ptt.nl>#1/1

"Kevin Bass" <akil1_at_mindspring.com> schrijfbewerkingen: > I have attempted to print output from a PL/SQL program into a file but
> received no results. Are there any other ways to print information (data)
> into a file without using DBMS_OUTPUT.PUT_LINE or DBMS_OUTPUT.PUT? If so,
> please send sample code.
>
> Kevin
>
>

First execute the following statement to get your DBMS_OUTPUT to generate output:

SET SERVEROUTPUT ON [SIZE size in bytes, maximum 1000,000)]

Or, alternatively, gather your data in a temporary file and spool it with a SELECT command.

Jaap. Received on Fri Mar 20 1998 - 00:00:00 CST