Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Writing to a text file from PL/SQL
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
> >
> >
>
>
Received on Mon Jul 22 2002 - 13:11:55 CDT