Re: partially filled bind arrays?
From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 13 Mar 2006 11:49:16 +0100
Message-ID: <dv3inc$cub$1_at_nntp.fujitsu-siemens.com>
>> 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
Client 10.2.0.1 WinXP,
DML: insert into testtable (testcolumn) (:testbindarray)
Date: Mon, 13 Mar 2006 11:49:16 +0100
Message-ID: <dv3inc$cub$1_at_nntp.fujitsu-siemens.com>
[Quoted] DA Morgan schrieb:
> 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.
Client 10.2.0.1 WinXP,
DML: insert into testtable (testcolumn) (:testbindarray)
Lots of Greetings!
Volker
Received on Mon Mar 13 2006 - 11:49:16 CET