Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help on Determining Failed Rows in Array Inser/Update using OCI
I'm looking for some sample code or general insight on how to insert/update arrays of data with a single execute (oexn) call from within a C/C++ program.
I have successfully loaded data, but the tricky part is determining the rows that did not load within the array. For example I can load an array of 10 records, of which the 3rd & 6th have bad data so should not load, so I get a successful oexn with a row processed count of 8---which
is correct, but I'd like to know which rows did not load.
I've seen something regarding a return code field argument (rcodep) in one of the bind commands, but haven't seen an example.
Any insight would be appreciated Received on Thu Jul 24 1997 - 00:00:00 CDT