Re: writing into two files concurrently

abdoul85 wrote:
> I have problem:
> I want to write data into two files concurrently. spool and
> dbms_output.put_line doesn't provide this functionality. Is there any
> other way to write into the file.
>
> greetings
>

You can use DBMS_OUTPUT to do this. Simply open another file via a second file handle. Then use two PUT_LINE procs each using a different file handle. You will have to double up the PUT_LINE commands.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com