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’); […]
Techgoeasy
Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts
