Re: partially filled bind arrays?

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 12 Mar 2006 13:27:56 -0800
Message-ID: <1142198859.374763_at_yasure.drizzle.com>


Volker Hetzer wrote:
> Hi!
> I'm trying to use the oo4o driver with bind arrays for inserts.
> Now, when inserting a large number of rows, like 1000005,
> I create bind arrays for let's say, 10000 rows. Then I read the data
> from somewhere else, putthem into the bind arrya and whenever I've got
> 10000 rows, I insert. Which works fine, until I've done 1000000 rows.
>
> Then I read the last 5 rows and then what?
> Oracle complains aither about duplicate values or NULLs, depending onm
> wether the array was filled before.
>
> So, what do I do with the odd rows?
>
> Lots of Greetings!
> Volker

Insufficent information, beginning with the Oracle version number and lack of DML, to help you.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Mar 12 2006 - 22:27:56 CET

Original text of this message