| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> UTL_FILE.INVALID_PATH Exception
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: SCHMITT_at_ADMIN.UWEX.EDU
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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). Received on Sat Feb 09 2002 - 20:17:27 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |