Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL and input files

Re: PL/SQL and input files

From: <andreas.prusch_at_sintec.de>
Date: Sun, 24 May 1998 07:10:23 GMT
Message-ID: <6k8h4v$fl7$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US