How to Solve ORA-29280: invalid directory path

ORA-29280: invalid directory path  is a common error when doing file handling operations in the Oracle database Reason and Resolution for the error (1) This occurs if the directory specified does not exists in utl_file_dir init.ora parameter sqlplus / as sysdba show parameter utl_file_dir /tmp, /usr/tmp/ SQL> declare F_LOG utl_file.file_type; begin F_LOG := utl_file.fopen(‘/u500′,’j’, ‘w’); …

How to Solve ORA-29280: invalid directory path Read More »