Re: getting error on UTL_FILE.FOPEN

From: Muthu Kumar G <g.muthukumar_at_gmail.com>
Date: 10 Nov 2005 02:34:18 -0800
Message-ID: <1131618858.586254.57270@g44g2000cwa.googlegroups.com>

Arto,
Thanks for your help. But i guess you missed out the alternate part.

<-------------- OR ---------->

SQL> CREATE OR REPLACE DIRECTORY MY_OUT AS 'C:\'; Directory created.

SQL> CREATE OR REPLACE PROCEDURE UTL_FILE_TEST_READ   2 IS
  3 INPUT_FILE UTL_FILE.FILE_TYPE;   4 BEGIN

  5     INPUT_FILE := UTL_FILE.FOPEN ('MY_OUT','123.log','R');
  6     DBMS_OUTPUT.PUT_LINE('123');
  7     UTL_FILE.FCLOSE(INPUT_FILE);

  8 EXCEPTION
  9 WHEN OTHERS THEN
 10 DBMS_OUTPUT.PUT_LINE('ERRM -> ' || SQLERRM);  11 END UTL_FILE_TEST_READ;
 12 /

Procedure created.

SQL> EXEC UTL_FILE_TEST_READ;
ERRM -> ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line
475
ORA-29283: invalid file operation

PL/SQL procedure successfully completed.

SQL> Received on Thu Nov 10 2005 - 04:34:18 CST