Thanks Roman but I'm not sure I understand this, the BEGIN..END looks
null to me.

WHEN SQLCODE -803 DO BEGIN
END;

Just out of curiosity and moving on from the stored procedure, what is
the behavior if I did this?

for ( Iterator it = records.iterator(); it.hasNext(); )
{
Record record = it.next();

try
{
insertIntoOneTable( con, record );
}
catch ( DuplicateKeyException e )
{
// just continue
}
}

con.commit();

public void insertIntoOneTable( con, record ) throws ...
{
// this just does an insert into a single table
}

What would happen here?

R.