If you execute the script directly as
DECLARE BEGIN -- your code using UTL_FILE END; /
the script seems to work correctly, but if you wrap it into a stored procedure if gives you the ORA-29289 error, like that:
CREATE OR REPLACE PROCEDURE "MY_PROCEDURE" AS BEGIN -- your code using UTL_FILE END;
So, to solve this, simply add AUTHID CURRENT_USER option to your procedure declaration, like this:
CREATE OR REPLACE PROCEDURE "MY_PROCEDURE" AUTHID CURRENT_USER AS BEGIN -- your code using UTL_FILE END;
And it should now work correctly.
thank you so much, that resolved my issue
ReplyDelete