Re: Accessing Windows based file from Oracle 10G on UNIX

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: 20 Apr 2007 06:28:08 -0700
Message-ID: <1177075688.598069.236740@y80g2000hsf.googlegroups.com>

On Apr 20, 1:43 pm, dubey..._at_gmail.com wrote:
> Hi..
> I'm trying to access a set of files located at the windows folder
> (c:\temp) by using the UTL_FILE function. The database is located on
> the UNIX o/s. Oracle db version is 10.2.0.3. I have completed the
> directory setups as well. When the file is accessed it gives an error
> suggesting that there was an invalid file operation. Can anyone help?
> Thnx in advance

It sounds like you may have confused UTL_FILE the built in database package with the forms based TEXT_IO package? UTL_FILE is for database side operations and so the directory needs to be accessible from the database server, TEXT_IO is a client side library.

If you do wish to write to a shared filesystem on windows from a unix server you will need to get your relevant sysadmins to mount the share with appropriate permissions - we do this on Linux via SAMBA for some interfaces.

cheers

Niall Received on Fri Apr 20 2007 - 08:28:08 CDT