Re: read ascii file via pl/sql

Christian Mondrup <reccmo_at_sc03.sctp.dk> wrote in article <6a4cib$dfe$1_at_news.net.uni-c.dk>...
> Dave Lange <dlang_at_landolakes.com> wrote:
> : can I open and read a ascii file from a pl/sql program?
>
> According to the PL/SQL reference (release 2.3) I/O is not currently
> supported within PL/SQL. By using the DBMS_OUTPUT package you may
> display output from PL/SQL but as far as I can see no input is
> possible. I suggest that you install the DBD/DBI Oracle interface to
> Oracle. Have a look at the perl home page http://www.perl.com/
>

I suggest you look into the UTL_FILE utility. You can read, write, etc.

Alex Received on Mon Jan 26 1998 - 00:00:00 CET