Oracle/PLSQL: SQLCODE Function

What does the SQLCODE Function do?

The SQLCODE function returns the error number associated with the most recently raised error exception. This function should only be used within the Exception Handling section of your code:

EXCEPTION     WHEN exception_name1 THEN         [statements]

    WHEN exception_name2 THEN         [statements]

    WHEN exception_name_n THEN         [statements]

    WHEN OTHERS THEN         [statements]

END [procedure_name];

You could use the SQLCODE function to raise an error as follows:

EXCEPTION    WHEN OTHERS THEN       raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM); END;

Or you could log the error to a table as follows:

EXCEPTION    WHEN OTHERS THEN       err_code := SQLCODE;       err_msg := substr(SQLERRM, 1, 200);

      INSERT INTO audit_table (error_number, error_message)       VALUES (err_code, err_msg); END;

Learn more about the SQLERRM Function.