Re: read ASCII file in PL/SQL

Bob Henke wrote:
>
> -- I want to read in an ASCII file and build oracle tables from it and I am
> having a few problems.
> 1) On a Unix box with oracle7.3 I tried using the UTL_FILE.FOPEN but I get
> a INVALID PATH error
> My book PL/SQL states that the path must be explicitly defined in my
> init.ora file but I cant find any
> references to it. Any Ideas or help???
> 2) I then tried to do the same thing on a win95 box with PO7 and it seems
> that PO7 does not even have
> the UTL_FILE package............
> I am at my wits end as what to do, any help or code snips would be welcome.
>
>
> Thanks......bob

Unfortunately the UTL_FILE procedure works fine except you need a line added
to config.ora that is like "utl_file_dir = *" which is slightly different than
what the manual implies.

Terry Received on Thu Apr 17 1997 - 00:00:00 CDT