Brian Peasland wrote:
> 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
But it will be serialized not written in parallel (concurrently).
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Oct 19 2007 - 02:07:22 CDT
