SQL>
SQL> set serveroutput on
SQL>
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(10): ' || SQLERRM(10));
5 DBMS_OUTPUT.PUT_LINE('SQLERRM: ' || SQLERRM);
6 DBMS_OUTPUT.PUT_LINE('SQLERRM(-1): ' || SQLERRM(-1));
7 DBMS_OUTPUT.PUT_LINE('SQLERRM(-54): ' || SQLERRM(-54));
8 END;
9 /
SQLERRM(0): ORA-0000: normal, successful completion
SQLERRM(100): ORA-01403: no data found
SQLERRM(10): -10: non-ORACLE exception
SQLERRM: ORA-0000: normal, successful completion
SQLERRM(-1): ORA-00001: unique constraint (.) violated
SQLERRM(-54): ORA-00054: resource busy and acquire with NOWAIT specified
PL/SQL procedure successfully completed.
SQL>
SQL>
|