Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: utl_file
pawan_test wrote:
> Hi all,
>
> i have a oracle procedure. it uses the Oracle supplied package UTL_FILE
> to read and write files that are located on the server.
>
> is there any other oracle supplied package available to read or writes
> files. if there is not such package available then can anyone please
> suggest me if there is any other alternate method available in oracle
> to read and writes files on the server.
>
> Thanks
> pavi
>
Depending on exactly what you are trying to achieve, Data Pump can write to external files and with External Tables, you can read from those files.
But why not use UTL_FILE? Does it not meet your requirements?
HTH,
Brian
-- =================================================================== Brian Peasland oracle_dba_at_nospam.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" - UnknownReceived on Mon Jun 19 2006 - 21:15:10 CDT