Re: UTL_FILE.INVALID_PATH Exception

We had a very similiar problem here. Not sure what caused it, but by stopping and restarting the listener, the issue went away. Go figure.

ps. we are also on AIX, with a mix of 8.1.7.2 and 7.3.4

      02/09/2002 06:03 PM PST Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> cc:

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 Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: 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).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tracy Rahmlow
  INET: Tracy.Rahmlow_at_aexp.com

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: 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).