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: Andrew Hardy <nobody_at_spam.from.news.AdvanticaTech.com>
Date: Mon, 22 Jul 2002 08:44:44 +0100
Message-ID: <ahgd6a$c11$1@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 - 02:44:44 CDT

Original text of this message

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