Re: PL/SQL and input files
From: Marcel Claus <Marcel.Claus_at_Informatik.Uni-Oldenburg.DE>
Date: Mon, 25 May 1998 16:43:05 +0100
Message-ID: <6kc00i$paq_at_news.Informatik.Uni-Oldenburg.DE>
Date: Mon, 25 May 1998 16:43:05 +0100
Message-ID: <6kc00i$paq_at_news.Informatik.Uni-Oldenburg.DE>
Kevin Bass 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
There is a package called TEXT_IO. Look in the docu for
the usage of TEXT_IO.FOPEN, TEXT_IO.GET_LINE, and
TEXT_IO.FCLOSE.
With these procedures you can write your own input-proc.
Otherwise you can use SQL*Loader from the commandline
Marcel Received on Mon May 25 1998 - 17:43:05 CEST