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: pl/sql io

Re: pl/sql io

From: <cmohan_at_iname.com>
Date: Mon, 13 Apr 1998 11:33:26 -0600
Message-ID: <6gteom$5tj$1@nnrp1.dejanews.com>


If you are using PL/SQL 2.3, there is a package called UTL_FILE. This is a good option. If you are using 2.2, then your only option is DBMS_OUTPUT.

Good luck,
CM

In article <3530C882.16E1A91F_at_hotmail.com>,   ofir <ofir_at_hotmail.com> wrote:
>
> Hi,
> There is a pakage call : DBMS_OUTPUT
> and have prodcedure that handle files
> (like get_line...)
>
> Ofir
>
> Martin Meadows wrote:
> >
> > I have to write a program to read an ascii file & load the data into a
> > table. I would like to use pl/sql to do this but I don't see any way to
> > open the file & read it with this language. Is there any way?
> >
> > Thanks,
> > Martin Meadows
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Apr 13 1998 - 12:33:26 CDT

Original text of this message

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