Home » Open Source » Programming Interfaces » ODP.NET - array binding - continue after exception (ODP 11.1.0.7.20, Oracle 8.1.7, Solaris)
ODP.NET - array binding - continue after exception [message #451901] Sun, 18 April 2010 10:20 Go to next message
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!
Re: ODP.NET - array binding - continue after exception [message #452568 is a reply to message #451901] Thu, 22 April 2010 11:11 Go to previous message
Averell
Messages: 17
Registered: November 2006
Junior Member
I just found out that this problem doesn't exist in Ora 9.2.0.8.0. I tried with this Oracle version, and followed http://download.oracle.com/docs/html/B10961_01/features.htm#1025579. And it is good.

But I still need to find a solution for my Ora8i, as that's my live server.
Please help me!

Thank you very much!
Previous Topic: odp .net 64bit problem
Next Topic: mandatory columns
Goto Forum:
  


Current Time: Tue Nov 19 15:51:15 CST 2019