SQLERRM system function : SQLERRM SQLCODE « Miscellaneous Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Miscellaneous Functions
3. SQLERRM SQLCODE

SQL>
SQL> set serveroutput on
SQL> BEGIN
  2    DBMS_OUTPUT.PUT_LINE('SQLERRM(0): ' || SQLERRM(0));
  3    DBMS_OUTPUT.PUT_LINE('SQLERRM(100): ' || SQLERRM(100));
  4    DBMS_OUTPUT.PUT_LINE('SQLERRM: ' || SQLERRM);
  5    DBMS_OUTPUT.PUT_LINE('SQLERRM(-1): ' || SQLERRM(-1));
  6  END;
  7  /
SQLERRM(0): ORA-0000: normal, successful completion
SQLERRM(100): ORA-01403: no data found
SQLERRM: ORA-0000: normal, successful completion
SQLERRM(-1): ORA-00001: unique constraint (.) violated

PL/SQL procedure successfully completed.

SQL>
SQL>