Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL and input files
Don't forget to set the init.ora parameter utl_file_dir. This parameter
will set to the path where the Oracle server is allow to read files.
Also remember that the procedure will execute on the server.
In article
<6k7oa3$4b$1_at_camel29.mindspring.com>,
"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
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sun May 24 1998 - 02:10:23 CDT