Home » Developer & Programmer » Precompilers, OCI & OCCI » Duplication in OCI Batch mode insertion problem
Duplication in OCI Batch mode insertion problem [message #265455] Thu, 06 September 2007 06:24
Messages: 1
Registered: September 2007
Junior Member

We are using OCI batch mode for inserting records into table in the batchmode. The table has primary key formed by combining multiple columns.
The table has 2000 records and we are inserting 4096 records using OCI's batch mode feature. Out of these 4096 records, 2000 are same as existing one in the table. So ideally, the table should have
4096 records. But surprisingly we found, 4096+ records with some duplicates records from those 2000 records. The OCI throws an error "UNIQUE key violation" for these 2000 records but some how records are getting inserted out of these 2000 record without respecting the primary key.

Does any one knows the problem or its OCI bug?

Waiting for reply.

Thanks and with warm regards,

Previous Topic: Signal handling with osnsui & osncui
Next Topic: Linking errors!!
Goto Forum:

Current Time: Mon Jun 27 00:54:24 CDT 2022