Re: UTL_FILE fopen exception

"andrija" <ar35644_at_fer.hr> wrote in message news:<a1eua3$79u8$1_at_as201.hinet.hr>...
> > I am trying to use UTL_FILE to read data from a file and load a number
> > of tables. I get a User Defined Exception when I run the FOPEN
> > function. The utl_file_dir parameter is set to *. Is there anything
> > else I need to set in order to use the UTL_FILE package.
> >
> > Thanks
> > John
>
> Why not use SQL*Loader?

Thanks to all who replied.

I loop through a list of files and read certain columns based on offsets stored
in a table and then load the data read into a number of tables. (Reason for not using SQL*LOADER. Some files have 200+ columns whereas I only require 2 or 3 of them)

A couple of files had incorrect permissions including the first file I was trying to access.

Thanks again
John Received on Wed Jan 09 2002 - 10:52:53 CET