| ODP.NET - array binding - continue after exception [message #451901] |
Sun, 18 April 2010 10:20  |
Averell
Messages: 17
Registered: November 2006
|
Junior Member |
|
|
Dear all,
I'm using C# with ODP 11.1.0.7.20, array binding to do bulk insert into a table in Oracle 8.1.7. Within the inserting rows, some violate the UNIQUE CONSTRAINT.
With the default behaviour, the whole process is rolled-back, and no rows are inserted.
If I use a transaction control, and do commit in the "catch" block (as exampled in http://www.kods.net/net-to-call-oracle-stored-procedure-use-an-array-of-types-of-parameters-such-as-arraylist/), I have all rows before the violating row inserted. But, in the exception, I could not know which row is the violating one.
But, neither of the two behaviours above meets my expectation. What I need is to have the rows after the violating row inserted too.
Or, at least, to follow the 2nd behaviour above, but let me know which row is the violating one, so I can manually continue with the next ones.
Could you please help me?
Thank you very much!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
