WHENEVER SQLERROR EXIT
INSERT INTO SCHEMA.TABLE1 (FIELD1, FIELD2, FIELD3) 
VALUES (VALUE1, VALUE2, VALUE3);
INSERT INTO SCHEMA.TABLE (FIELD1, FIELD2, FIELD3) 
VALUES (VALUE1, VALUE2, VALUE3);
INSERT INTO SCHEMA.TABLE (FIELD1, FIELD2, FIELD3) 
VALUES (VALUE1, VALUE2, VALUE3);
...

-- Here it makes an insert in TABLE2, summing up the inserts
-- made in TABLE1
INSERT INTO SCHEMA.TABLE2 (NUMBER_OF_ROWS, DATA1, DATA2)
VALUES (CSV_ROWS_NUMBER, VALUE1, VALUE2);

-- And then commits
COMMIT;

WHENEVER SQLERROR EXIT
INSERT INTO SCHEMA.TABLE1 (FIELD1, FIELD2, FIELD3) 
VALUES (^@VALUE1^@, ^@VALUE2^@, ^@VALUE3^@);
INSERT INTO SCHEMA.TABLE (FIELD1, FIELD2, ^FIELD3) 
VALUES (^@VALUE1^@, ^@VALUE2^@, ^@VALUE3^@);
INSERT INTO SCHEMA.TABLE (FIELD1, FIELD2, FIELD3) 
VALUES (^@VALUE1^@, ^@VALUE2^@, ^@VALUE3^@);
...

INSERT INTO SCHEMA.TABLE2 (NUMBER_OF_ROWS, DATA1, DATA2)
VALUES (CSV_ROWS_NUMBER, VALUE1, VALUE2);

COMMIT;

C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Sam. Ao¹t 14 09:28:40 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> @c
Connected.
SQL> drop table table1;

Table dropped.

SQL> create table table1 (field1 varchar2(100), field2 varchar2(100), field3 varchar2(100));

Table created.

SQL> WHENEVER SQLERROR EXIT
SQL> INSERT INTO SCHEMA.TABLE1 (FIELD1, FIELD2, FIELD3)
  2  VALUES (^@VALUE1^@, ^@VALUE2^@, ^@VALUE3^@);
VALUES (^@VALUE1^@, ^@VALUE2^@, ^@VALUE3^@)
        *
ERROR at line 2:
ORA-00936: missing expression


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options

C:\>