partially filled bind arrays?
From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Fri, 10 Mar 2006 13:12:12 +0100
Message-ID: <durqes$i3f$1_at_nntp.fujitsu-siemens.com>
Hi!
[Quoted] [Quoted] I'm trying to use the oo4o driver with bind arrays for inserts. [Quoted] 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.
Date: Fri, 10 Mar 2006 13:12:12 +0100
Message-ID: <durqes$i3f$1_at_nntp.fujitsu-siemens.com>
Hi!
[Quoted] [Quoted] I'm trying to use the oo4o driver with bind arrays for inserts. [Quoted] 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
Received on Fri Mar 10 2006 - 13:12:12 CET