Error code and message : SQLERRM « PL SQL « Oracle PL / SQL





Error code and message

    

SQL>
SQL> CREATE TABLE myTable(col1 NUMBER);

Table created.

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
 10  EXCEPTION
 11      WHEN OTHERS THEN
 12        v_sqlcode := SQLCODE;
 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.

   
    
    
    
  










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: sql%bulk_exceptions(i).error_code
5.Trim the error message and then output
6.SQLERRM has the error message
7.Reference sql%bulk_exceptions(i).error_index