Catch different UTL_FILE related errors : UTL_FILE « System Packages « Oracle PL / SQL






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

   
  








Related examples in the same category

1.Writing "Hello World!" to a File
2.Use UTL_FILE.PUT_LINE to write a line of text to a file
3.Use utl_file.fopen to open a file
4.Use UTL_FILE.FCLOSE to close a file
5.Use UTL_FILE to read from a file and insert into the lecturer table.
6.Use UTL_FILE to print a transacript to a file.
7.Save data in a cursor to a file
8.Load the data into table myTable. You may use any valid number for column c1's data.