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






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>








17.4.SQLERRM SQLCODE
17.4.1.Use error functions SQLERRM and SQLCODE
17.4.2.SQLERRM has the error message
17.4.3.SQLERRM system function