Re: utl_file

Hello,

i have a procedure which reads a file from the server . it then writes the file to the database. the procedure uses UTL_FILE package to read and write the files onto the database.
can you please suggest me if there is any other alternate way in oracle to read files from server ( i.e unix) and writes files on the database.

thanks
pavi

G Quesnel wrote:
> pawan_test wrote:
> > Hi all,
> >
> > 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.
>
> Can you provide more information on what you are trying to achieve.
> External tables can be read and written to files, outside of your
> database.
> Import/export (including data pump) can write/read data and object
> structures.
> A number of tools can write reports to file (text or html - comma
> delimited or fixed width - ...).
> Blobs can be read from and stored in files outside the database.
> SQL Loader can read all kinds of text files.
> Even standard sqlplus with the a number of parameters can deliver file
> formating.
>
> Do you have a specific problem you are trying to get around of ?
> What is the content or format you want/need to use ?
Received on Mon Jun 19 2006 - 21:02:13 CDT