Re: getting error on UTL_FILE.FOPEN

Muthu Kumar G wrote:
> 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>
Did you grant READ on the directory?

And why would you choose the root? That is bad practice on any o/s.

Working demos can be found in Morgan's Library at www.psoug.org click on UTL_FILE.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)