ORA-29280: Invalid Directory Path With UTL_FILE.FOPEN
Last updated on JULY 05, 2017
Applies to:PL/SQL - Version 126.96.36.199 and later
Information in this document applies to any platform.
Executing a PL/SQL stored procedure to open a file on the file system where the Oracle Server is running using UTL_FILE.FOPEN() method is throwing the following exception
UTL_FILE.INVALID_PATH or an unhandled exception ORA-29280: invalid directory path
The directory to receive the file has already been created via the DDL statement CREATE DIRECTORY and permissions have been granted to the oracle user who is executing the PL/SQL procedure via the GRANT READ and GRANT WRITE statements.
The UTL_FILE.FOPEN statement quotes the actual directory path in the call
e.g. fh := UTL_FILE.FOPEN('/home/demo/schema/data', 'myfile.html','w',32767);
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms