ORA-29280: Invalid Directory Path With UTL_FILE.FOPEN (Doc ID 292961.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 9.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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);

Cause

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