Re: [Q]OCI: bulk insert
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 2 Sep 2000 17:46:59 +0200
Message-ID: <967909507.12695.0.pluto.d4ee154e_at_news.demon.nl>
Date: Sat, 2 Sep 2000 17:46:59 +0200
Message-ID: <967909507.12695.0.pluto.d4ee154e_at_news.demon.nl>
You should have no problem when you use the exceptions into clause at
primary key definition.
In that case the rowids of the offending rows will simply end-up in the
exceptions table without raising an exception in your OCI program.
Hth,
Sybrand Bakker, Oracle DBA
"Vlad" <pvlad_at_bigfoot.com> wrote in message
news:39B11C92.A2622B51_at_bigfoot.com...
> Hello,
> When doing bulk insert of say 600 records at a time, the insert fails
> because
> some records violate the unique index on the table.
> Can OCI C library tell me what exactly records in the block caused the
> failure?
> If yes, what is the function/datastructure that contains this info.
>
> Thanks in advance,
> Vlad
>
Received on Sat Sep 02 2000 - 17:46:59 CEST