Hi Again !
I just found this literature on the net :
According to the Oracle docs :
Oracle9i
JDBC Developer's Guide and Reference
Release 2 (9.2) chapter 12
Performance Extensions
"For a prepared statement batch, it is not possible to know which operation failed. The array has one element for each operation in the batch, and each element has a value of -3. According to the JDBC 2.0 specification, a value of -3 indicates that an operation did not complete successfully. In this case, it was presumably just one operation that actually failed, but because the JDBC driver does not know which operation that was, it labels all the batched operations as failures."
so does this mean, If i use prepared statements then i can't track how many records failed execution and how many succeeded is it ?
-Rohan