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.