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

abdoul85 wrote:
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 (DOT) 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

abdoul85 wrote:
Only if you write Java or C.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Oct 18, 11:10 am, DA Morgan <damor... (AT) psoug (DOT) org> wrote:
Abdoul85, what exactly are you trying to do? What interface (tool
set) are you using? What full version of Oracle?

Depending on the details there may be some combination of features
that will give you what you want such as using pl/sql code to write to
a file via utl_file while spooling dbms_output messages. It all
depends on details lacking from your post. Most likely you will need
an external routine (C code) or a pro*C or java program as Daniel
mentioned. Without more specific detail of what you are trying to do
no one can really provide you with useful suggestions.

HTH -- Mark D Powell --

Brian Peasland wrote:
But it will be serialized not written in parallel (concurrently).
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org