SQLERRM has the error message : SQLERRM SQLCODE « Miscellaneous Functions « Oracle PL/SQL Tutorial

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

SQL> create table myTable(acolumn number);

Table created.

SQL> set serveroutput on
SQL>
SQL> DECLARE
  2      v_sqlcode NUMBER;
  3      v_sqlerrm VARCHAR2(100);
  4  BEGIN
  5      FOR i IN 1..10000 LOOP
  6        INSERT INTO myTable VALUES (i);
  7      END LOOP;
  8      commit;
  9  EXCEPTION
 10      WHEN OTHERS THEN
 11        v_sqlcode := SQLCODE;
 12
 13        v_sqlerrm := substr(SQLERRM,1,80);
 14        dbms_output.put_line(v_sqlcode || v_sqlerrm);
 15    END;
 16  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> drop table myTable;

Table dropped.

SQL>