Trim the error message and then output : SQLERRM « PL SQL « Oracle PL / SQL






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

Trim the error message and then output

    

SQL>
SQL> CREATE TABLE myTable
  2  (col1 NUMBER,
  3   col2 NUMBER,
  4   col3 NUMBER);

Table created.

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

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