Invalid path when UTL

From: Edward Rusu <erusu_at_softcomputer.com>
Date: Mon, 9 Nov 1998 12:37:27 -0500
Message-ID: <7279m8$rco$1@scream.jriver.com>

Hi All!
I've got Oracle8 on AIX 4.2 system and I've tried to work with files from PL/SQL packages.
There is not examples in documentation so I had to guess what format of path name must be.
I used '/user/erusu', '/user/erusu/', '//user//erusu'. But it does not help. I gave to directory written permission to everybody, but INVALID_PATH exception is raising.
Here is my test example that does not work:

CREATE OR REPLACE PROCEDURE test_file IS

F UTL_FILE.FILE_TYPE;
BEGIN
F:=UTL_FILE.FOPEN('/user/erusu','test.ora', 'a'); UTL_FILE.PUT_LINE(F,'a line from ORACLE PL/SQL.'); UTL_FILE.FCLOSE(F);
EXCEPTION

    WHEN UTL_FILE.INVALID_PATH THEN
        DBMS_OUTPUT.PUT_LINE('invalid_path');
    WHEN UTL_FILE.INVALID_MODE THEN
        DBMS_OUTPUT.PUT_LINE('invalid_mode');
    WHEN UTL_FILE.INVALID_OPERATION THEN
        DBMS_OUTPUT.PUT_LINE('invalid_operation');
    WHEN OTHERS THEN
        DBMS_OUTPUT.PUT_LINE('others');

END;
/
SHOW ERRORS PROCEDURE TEST_FILE;
EXECUTE test_file;

The output is invalid_path :-(

So what is the matter?

Please, help me. Thanks for any tints.

Sincerely yours,
Eddie. Received on Mon Nov 09 1998 - 11:37:27 CST

Invalid path when UTL_FILE.FOPEN