Re: UTL_FILE fopen exception
From: MarkyG <markg_at_mymail.tm>
Date: 8 Jan 2002 02:39:02 -0800
Message-ID: <ab87195e.0201080239.28e48b84_at_posting.google.com>
Date: 8 Jan 2002 02:39:02 -0800
Message-ID: <ab87195e.0201080239.28e48b84_at_posting.google.com>
- Are you writing to a local drive? UTL_FILE only allows reading/writing to a drive on the Oracle SERVER.
- If reading from an Oracle Server drive, is the drive mapped? I personally have had this problem. There are issues regarding UTL_FILE and mapped drives, best to check MetaLink for them (www.oracle.com), in the support section. Safest bet is to use the UNC format (ie \\server\share) if it is a network drive you are reading/writing to.
- Is the operating system permissions enabled? Oracle will not overide them.
HTH, Mark
john_killeen_at_hotmail.com (Killeen) wrote in message news:<e05ea253.0201071038.577c22b6_at_posting.google.com>...
> Hi
>
> 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
Received on Tue Jan 08 2002 - 11:39:02 CET