Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting ERROR -29280 ORA-29280: invalid directory path in UTL_FILE

user2988171Aug 4 2010 — edited Aug 4 2010
Hi All,

When i'm executing below code, I'm getting the error

ERROR -29280ORA-29280: invalid directory path
declare
  v_MyFileHandle UTL_FILE.FILE_TYPE;
BEGIN
  v_MyFileHandle := UTL_FILE.FOPEN('$XXX_OUT', 'HELLO.TXT', 'a');
  
  UTL_FILE.PUT_LINE(v_MyFileHandle,
                    'Hello Again for the Second Time! ' ||
                    TO_CHAR(SYSDATE, 'MM-DD-YY HH:MI:SS AM'));
                    
  UTL_FILE.FCLOSE(v_MyFileHandle);
  
  null;
  
EXCEPTION
  WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('ERROR ' || TO_CHAR(SQLCODE) || SQLERRM);
    NULL;
END;
Please let me know if someone has any idea on this error.

Regards,
This post has been answered by 781735 on Aug 4 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2010
Added on Aug 4 2010
3 comments
1,373 views