to reproduce:

set up a oracle jdbc connection, "check form data input for required fields" is
set to false.

The table should at least contain one field (number, pk not null).

Create in Oracle a sequence which generates the values.

Create a trigger "before insert" which gets the generated values.

Create a form in base with a primary key field.

Insert a new record and leave the field empty.

What should happen: record stored, finito.

What happens: record stored, but message pops up "Exhausted resultset".
No chance to leave the form with the cursor, new records are inserted until you
make an update of the form and then refuse to store the new record.