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: HELP w/ PL/SQL writing to a flat file.

Re: HELP w/ PL/SQL writing to a flat file.

From: <twod_at_not.valid>
Date: 1997/11/11
Message-ID: <6491dj$s8d$1@vnetnews.value.net>#1/1

djdrew (drew1200_at_ix.netcom.com) wrote:
: I've gone through the documentation in the oracle programmer's reference
: and the O'Reilly books, but I can't seem to get PL/SQL to write to a
: flat file. Can anyone give me actual code that I may be able to use to
: perform this procedure?

Depends on what version of PL/SQL you are using, but have a look if you have the UTL_FILE package installed in your RDBMS. Running "select text from all_source where name = 'UTL_FILE';" will give you the parameters and some terse information on how to use the objects within the package.

IAP

--
In an attempt to reduce junk email I use an invalid 'From' address.
My correct email address can be determined by replacing 'not.valid' with 
'value.net'
Received on Tue Nov 11 1997 - 00:00:00 CST

Original text of this message

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