Re: read ascii file via pl/sql

From: Andrew Hodgson <andrew_at_tcamiga.demon.co.uk>
Date: 1998/01/21
Message-ID: <vvMFiHAkbnx0Mwn5_at_tcamiga.demon.co.uk>#1/1


In article <34C5CE11.52ED_at_celltech.co.uk>, James Petts <jpetts_at_celltech.co.uk> writes
>Dave Lange wrote:
>>
>> can I open and read a ascii file from a pl/sql program?
>
>Check out the UTL_FILE package.
>

Note:

Just to point out here folks, I got quite excited about UTL_FILE too, until I found out it was not available on versions before Oracle 7.3, so check your version is capable of providing this function, before attempting to get it to work.

           |    Andrew Hodgson - Andrew_at_tcamiga.demon.co.uk   |
           |                     www.tcamiga.demon.co.uk      |
           |  Amiga 1200 030 33Mhz    |       6x86 P150+      |
           | 250Mb HD   HD Disk Drive | Quad Spd CD 5.3 Gb HD |
           | 6Mb Ram | CDTV | Motorola SurfR 56K |  80Mb Ram  |
                           Resistance is futile...
Received on Wed Jan 21 1998 - 00:00:00 CET

Original text of this message