Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

Catch different UTL_FILE related errors

SET ECHO ON SET SERVEROUTPUT ON DECLARE      emp_data UTL_FILE.FILE_TYPE; BEGIN     emp_data := UTL_FILE.FOPEN ('c:\a','empdata.csv','W');     UTL_FILE.FCLOSE (emp_data); EXCEPTION     WHEN UTL_FILE.internal_error THEN         DBMS_OUTPUT.PUT_LINE ('UTL_FILE: An internal error occurred.');         UTL_FILE.FCLOSE_ALL;     WHEN UTL_FILE.invalid_filehandle THEN         DBMS_OUTPUT.PUT_LINE ('UTL_FILE: The file handle was invalid.');         UTL_FILE.FCLOSE_ALL;     WHEN UTL_FILE.invalid_mode THEN         DBMS_OUTPUT.PUT_LINE ('UTL_FILE: An invalid open mode was given.');         UTL_FILE.FCLOSE_ALL;     WHEN UTL_FILE.invalid_operation THEN         DBMS_OUTPUT.PUT_LINE ('UTL_FILE: An invalid operation was attempted.');         UTL_FILE.FCLOSE_ALL;     WHEN UTL_FILE.invalid_path THEN         DBMS_OUTPUT.PUT_LINE ('UTL_FILE: An invalid path was give for the file.');         UTL_FILE.FCLOSE_ALL;     WHEN UTL_FILE.read_error THEN         DBMS_OUTPUT.PUT_LINE ('UTL_FILE: A read error occurred.');         UTL_FILE.FCLOSE_ALL;     WHEN UTL_FILE.write_error THEN         DBMS_OUTPUT.PUT_LINE ('UTL_FILE: A write error occurred.');         UTL_FILE.FCLOSE_ALL;     WHEN others THEN         DBMS_OUTPUT.PUT_LINE ('Some other error occurred.');         UTL_FILE.FCLOSE_ALL; END; /