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,