SQLERRM has the error message : SQLERRM « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. SQLERRM

SQLERRM has the error message

    

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>








Related examples in the same category

1.SQLERRM function.
2.SQLERRM function returns the error message associated with the most recently raised error exception
3.sqlerrm(sql%bulk_exceptions(i).error_code)
4.Error code and message
5.Error code: sql%bulk_exceptions(i).error_code
6.Trim the error message and then output
7.Reference sql%bulk_exceptions(i).error_index