Re: getting error on UTL_FILE.FOPEN

Muthu Kumar G schrieb:
> 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>
>

This very likely means that the file 'C:\123.log' doesn't exist ( it should be existent prior to be opened in 'R' mode).

Best regards

Maxim Received on Thu Nov 10 2005 - 05:08:45 CST