Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: writing into two files concurrently

Re: writing into two files concurrently

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 18 Oct 2007 09:35:28 -0700
Message-ID: <1192725328.540231.235780@e9g2000prf.googlegroups.com>


On Oct 18, 11:10 am, DA Morgan <damor..._at_psoug.org> 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
>
> Only if you write Java or C.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

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 -- Received on Thu Oct 18 2007 - 11:35:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US