I am doing some batch deletion.
When i am deleting some records from a particular table,if there
are any child records found for a particular statement
in the batch ,will the oracle thin driver
proceed with the rest of the statements in the batch ?
Currently ,i dont think it is doing so.
I used the batchupdateexception.getUpdateCounts and checked for value of -3
(which means statement failed) in the array.
after the non successful record,
it is giving -3 for the statements which dont have child records and
should be deleted.Is there any work around for this ?
In my batch operation,i must be able to identify only those deletions (of records)
which violate the referential constraint for the child record.
I cant do this in a seperate select query.
Can somebody pls help ?
Thanks
Naveen.N