Originally posted by N Naveen:
Hi,
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
Naveen, I'm not quite sure what you are trying to do. Do you want to delete those rows in parent that don't have any child rows? If so, you can write your delete statement with the where clause of something like the following:
delete parent table where <yr conditions> and not exists (select 1 from child table where child.keys = parent.keys).