ORA-06512 + System.Data.OracleClient error

[Guest]

Hi

I am having getting Oracle error ORA-06512 when my .NET serviced component
tries to participate in a COM+ transaction. I am using
System.Data.OracleClient with VS.NET 2003 (i.e. Framework 1.1) on Windows
2000 SP3 and Oracle 9.2.0.4.

If I change my code to use System.Data.OleDB then everything works fine, but
for us this is not an option as we have far too much code written that is
using OracleClient.

I found

http://www.dotnet247.com/247reference/msgs/43/217525.aspx
http://www.dotnet247.com/247reference/msgs/39/197274.aspx

talking about this problem. Someone from Microsoft even mentions it as known
bug.

Has anyone got a fix for this problem? We are in a desparate hurry and I
need to solve this problem asap.

Thanks
Bikhod

 

[Roy Fine]

bikhod

what was the exception code before the 06512 - that will likely give more
info.

As a side note - make sure you are not doing a commit - either implicit or
explicit.

regards
roy fine

 

[Guest]

Hi Roy

I forgot to paste the full Oracle error which is:

ORA-02049: timeout: distributed transaction waiting for lock
ORA-06512: at "SIPP_TEAM.PKG_MIDDLE_TIER_FRAMEWORK", line 126

My code is doing the following:

I have a VB6 COM component that inserts a new Customer into Oracle and
return the primary key for the new customer. I then have a .NET serviced
(COM+) component that takes take the customer primary key and attempts to
inserts the customer's account record. There is a parent-child relationship
between Customer and Account tables, with the latter having a foreign key
constraint to the Customer table.

The ORA-02049 error occurs in my PL/SQL insert into Account ... line.

If I disable the foreign key constraint everything works. As I mentioned
before, if I use System.Data.OleDB everything works. Unfortunately, neither
are an option.

By the way, I don't understand your side note - as a COM+/serviced component
I have to vote one way or another if I happy with my transaction. Dont I?

Thanks
Bikhod