OnArrayError and Refeerntial integrity violated

[flobo]

Hi:

I'm inserting records using array DML, and i found a very strange behaviour in one case:

if there is a row of the array that contains data that violated referential integrity then OnArrayError is triggered and shows ORA-2291. That's Ok. However index is always 0, and wrong data row may be 15, for example. Then ALL rows in Array triggers OnArrayError with ORA-0001(Unique Constraint violated), but this is false. And finally, all rows are inserted no matter errors showed during the process.

Thanks in advance.

 

[Marco Kalter]

That doesn't seem right. How can you get an exception for all records, and yet all records are inserted? It seems to me that the records were already present, hence the unique key violation.

Can you send me a simple project and table to reproduce this?

------------------
Marco Kalter
Allround Automations