Re: PL/SQL and input files
Date: Thu, 28 May 1998 16:57:31 -0600
Message-ID: <356DEBDB.9C1B6B99_at_earthlink.net>
Hi Kevin,
Oracle comes with a package known as UTL_FILE. This package allows developers the ability to interface with text files stored on the file system. In order to utilize the package, your DBA will need to add the following parameter to the INIT.ORA file:
utl_file_dir = some_place
To use the package, refer to the Application Developers manual. The package is very simple to use.
Good Luck,
John M. Reed Jr.
Developer/DBA
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
Received on Fri May 29 1998 - 00:57:31 CEST