Hi -
I have a procedure procA owned by userAwhich calls the utl_file
procedure to open and read a text file. The procA procedure
functions properly when it is run in SQL*Plus from the server.
However, when the procA procedure is executed from a client PC using
SQL*Plus (or SQLNavigator), the UTL_FILE.FOPEN call fails with the
INVALID_PATH exception.
The following is the line that fails in procA:
PCARD_FILE := UTL_FILE.FOPEN ('/u/schmitt/out', 'PC020204.TXT',
'R');
The following is the results of select name, value from v$parameter
where name = utl_file_dir:
NAME VALUE
utl_file_dir /u/schmitt, /u/schmitt/out, /tmp
We are running Oracle 8.1.7 on an IBM RS/6000 with AIX.
The privileges on the /u/schmitt/out
directory are drwxrwxrwx and the PC020204.TXT privileges are set to
-rwxrwxr--.
This same procedure worked just fine when executed from either the
client or the server in an Oracle 8.1.5 instance on this same server
using the same files and the same directory.
Any ideas why this procedure fails when it is executed from the
client PC but not when it is executed from the server? Any ideas
what changed in Oracle 8.1.7 when trying to use the UTL_FILE
package?
Thanks in advance for your help.
Janet.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Schmitt 265-3334
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
