Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help on Determining Failed Rows in Array Inser/Update using OCI

Help on Determining Failed Rows in Array Inser/Update using OCI

From: John R. Brown <john.brown_at_systecinc.com>
Date: 1997/07/24
Message-ID: <33D7C4A6.D4174B8A@systecinc.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US