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

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

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