Re: Writing to a text file from PL/SQL

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 - 03:03:14 CDT