Re: help! any known Pro*C arrayinsert indexing bugs??

Dan,

I've written a large data mining app which uses arrays exclusively for insert/updates. It's now more than 2x faster than when I was doing singleton transactions. I encountered similar problems and elected to check referential constraints as I load the arrays. That way, if something is awry, I can handle it without the insert/update puking.

flaggedatbest_at_yahoo.com wrote:

> Hello.
>
> I am using Pro*C version 8.0.5.1.0 and HPUX version 11.0.
>
> I have a C program that does array inserts. If the array insert fails
> because of a constraint error, I reload the array by reindexing
> the array (I copy the array to a temp array where entry 0 is the
> entry after the one that Oracle flagged as a violation) I use
> a 'for' clause to indicate the smaller array.
>
> I am using the sqlca.sqlerrd[2] value to determine how many records
> were successfully loaded.
>
> I found that in my testing that sqlca.sqlerrd[2] did not contain the
> correct index. Consistantly, if in the current batch that I was loading
> there was a contraint violation, It always seemed to be off by 170 records.
>
> Is this a known problem???
> Any advice appreciated!!
>
> -Dan
> dantill_at_nationalfraud.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Apr 01 1999 - 16:01:54 CST