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

Home -> Community -> Usenet -> c.d.o.misc -> Re: help! any known Pro*C arrayinsert indexing bugs??

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

From: Scott Dudley <scott_at_telesoft.com>
Date: Thu, 01 Apr 1999 15:01:54 -0700
Message-ID: <3703ECD2.EB7E8B22@telesoft.com>

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

Original text of this message

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