Re: Clearing buffer in PL/SQL

In article <4mdcij$190i_at_watnews1.watson.ibm.com> mlanda_at_vnet.ibm.com wrote:

> In <318AA666.11DD_at_pacific.net.sg>, Mageshwar Sivagnanam <magesh_at_pacific.net.sg>  writes:
>>Hi ne1 out there,
>>
>>I have created a PL/SQL script as follows. The fundu. objective of this script is to
>>read a set of tables (master-detail) and place/write them into a file. The script goes
>>something like this :
 

>>The problem is that I get a buffer overflow. [No I cannot increase the serverout size to
>>the max. value of 1 million bytes, since then I can only get 4000 odd records, by this
>>method.] The core issue here seems to be clearing the buffer (akin to fflush in 'C') and
>>i'm unable to do that. There is an option in SQL*Plus, but again I'm not able to
>>implement the SQL*Plus command in the PL/SQL block.
 

> Another option is to use a database pipe to send your records from a
> database procedure to a host c program and then write them to a file.
> Look up DBMS_PIPE in the Application Developer's Guide for more
> information and examples.
> 

If you want to stay out of writing a C program, and you have version 7.3 loaded with version 2.3 of PL/SQL you can use the UTL_FILE package to output to a file with the put function. Received on Sat May 04 1996 - 00:00:00 CEST