Re: output to file (unix)
From: Sandor Nieuwenhuijs <snieuwen_at_nl.oracle.com>
Date: Sat, 11 Jun 1994 14:41:12 GMT
Message-ID: <Cr8M4p.EA8_at_nl.oracle.com>
Date: Sat, 11 Jun 1994 14:41:12 GMT
Message-ID: <Cr8M4p.EA8_at_nl.oracle.com>
Todd Helfter (tmh_at_staff.cc.purdue.edu) wrote:
: Does anyone know of a way to output to multiple files
: from a pl/sql procedure. The filenames being made up from
: a field.
As far as I know, you cannot do this with dbms_output, you can very easily simulate this by writing a server proces, which connect to the database, and interacts with your PL/SQL procedures using dbms_pipes, you can e.g. write a Stored Procedure Put_file (filename, string), which sends the filename and the string to the server proces via a database pipe/ The server process will then output this to the required file.
Sandor Nieuwenhuijs
Oracle Netherlands
Received on Sat Jun 11 1994 - 16:41:12 CEST