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

pawan_test <sridhara007 (AT) gmail (DOT) com> wrote:
For reading files you can use external tables since ver 9i
if files are csv-like
http://www.oracle.com/technology/pro...ly/sept19.html

I don't know any simpler method for writing
files than utl_file. Note that writing is quite dangerous as the process
runs with oracle user privileges.

Rgds,
--
Marek Trofimiuk < mt20863 (at) sgh waw pl >
Primary key fingerprint: FA3C 14D8 020F FA0C 70AE 930C F63F F04B 2ADD 9DD7