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: utl_file

Re: utl_file

From: pawan_test <sridhara007_at_gmail.com>
Date: 19 Jun 2006 19:02:13 -0700
Message-ID: <1150768933.919899.194850@i40g2000cwc.googlegroups.com>


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

Original text of this message

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