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: Writing to a text file from PL/SQL

Re: Writing to a text file from PL/SQL

From: Jeff Smith <jsmit234_at_ford.com>
Date: Mon, 22 Jul 2002 14:11:55 -0400
Message-ID: <ahhgso$cjh10@eccws12.dearborn.ford.com>


 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

Original text of this message

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