Hi there,

In may application I have 2 tables: parent and a child. At some point I delete some rows from the parent table. According with the settings, also the corresponding rows from the child table will be deleted. But, in the same transaction, I make some inserts in the parent table; it is possible, to have some data within this inserts, that were previously deleled (see above). Oracle throws an error saying some unique constraint was violated. Theoretically, this should not happened because the old row that could cause the violation was deleted (see above).

I hope I made my self clear.

Thanks a lot.