Re: Writing to a text file from PL/SQL

Jeff Smith wrote:

> select * from all_objects where OBJECT_name = 'UTL_FILE'
>
> "Jasna Prester" <jasna.prester_at_viadukt.tel.hr> wrote in message
> news:ahgeh9$74j9$1_at_as201.hinet.hr...
> > Thank you Andy for your quick answer.
> >
> > Where do I find UTL_FILE package?
> >
> > Thanks again,
> >
> > Jasna
> >
> > "Andrew Hardy" <nobody_at_spam.from.news.AdvanticaTech.com> wrote in message
> > news:ahgd6a$c11$1_at_sun-cc204.lut.ac.uk...
> > > Jasna,
> > >
> > > > I'm trying to retrive data from an Oracle table into a text file by
> the
> > > sql
> > > > procedure wich is atached to this mail but I get following declaration
> > > > mistakes:
> > > >
> > > > Input truncated to 1 characters
> > > > f TEXT_IO.FILE_TYPE;
> > >
> > > Text_IO is an Oracle Forms package. If you want to do file IO on the
> > > server/sql*plus have a look at the UTL_FILE package.
> > >
> > > Andy
> > >
> > >
> >
> >

Also

desc UTL_FILE

and

SELECT *
FROM all_arguments
WHERE package_name = 'UTL_FILE'

and look at the following files in $ORACLE_HOME\rdbms\admin

dbmslmd.sql
utlfile.sql

Daniel Morgan Received on Mon Jul 22 2002 - 14:34:26 CDT