Re: PL/SQL and input files

From: Peter Schneider <peter.schneider_at_okay.net>
Date: Sun, 24 May 1998 15:07:18 GMT
Message-ID: <35683716.543009@news.okay.net>

On Sat, 23 May 1998 19:59:17 -0400, "Kevin Bass" <akil1_at_mindspring.com> wrote:

>Is it possible to read the data from an input file into a PL/SQL block?. An
>example would like a file with the format of:
>
>123456789 Doe John
>987654321 Doe Jane
>
>Could this data be read into a PL/SQL block and used within the block?
>
>
>Kevin

Hi Kevin,

the UTL_FILE package on the server side and the TEXT_IO package in the client side (ie Oracle Forms) are those that can do this job. But this will require some programming to parse the file format, eg to parse and seperate the fields in a logical record.

HTH
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Sun May 24 1998 - 10:07:18 CDT