Oracle error when i use System.Data.OracleClient 1.0.5000.0

[Guest]

Hi,

I am calling an oracle built in procedure pkg_util.compile_schema from my
VB.NET code this throws an excpetion ORA-02074: cannot ALTER PACKAGE COMPILE
in a distributed transaction ORA-06512: at "SYS.DBMS_UTILITY", line 425
, this was working fine when i used with .NET 1.0 System.Data.OracleClient
1.0.3300.0 version, recently we moved to .NET 1.1 that uses
System.Data.OracleClient 1.0.5000.0 assembly and causing the above problem.

The database we are using currenly is Oracle 9i

is this the normal behaviour / is there any work around to solve this problem?

TIA
ram

 

[Guest]

My suggestion, with Oracle, is to move to ODP.NET (free from
http://otn.oracle.com). The original Microsoft OracleClient classes were
written against 8i (and MAY have been tested against early 9i builds). As
Oracle routinely changes internals, it is best to stick with their providers.

NOTE: If you move to 10g, you will have to move to ODP.NET (the version
specifically for 10g).


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

 

[Eric]

Hi,

I am calling an oracle built in procedure pkg_util.compile_schema from my
VB.NET code this throws an excpetion ORA-02074: cannot ALTER PACKAGE COMPILE
in a distributed transaction ORA-06512: at "SYS.DBMS_UTILITY", line 425

This looks like something caused this DBMS_UTILITY package to be
invalidated, and Oracle is trying to automatically recompile it. This
recompile is failing because you're apparently using it in a distributed
insert/update (using a dblink). Maybe you're executing a stored proc
that is using this package - it might not appear directly in your code.

See if your DBA can recompile this package for you.

I don't think this particular error has anything to do with the provider
upgrade. I assume you can execute some SQL correctly, right? I found the
MS Oracle provider to work quite well on Oracle 9i, but I agree with
Cowboy that ODP is likely to be your best choice, especially if you need
the more advanced features.

I'm not saying you should go into a lot of exiting programs and change
their provider to ODP. This is something you can phase in with new programs.

Did you also change your TNSNAMES.ORA file? Did you change the user
identity being used? Did you change your version of the actual Oracle
client software?

Eric

 

[Guest]

Eric,

We havent changed anything from the one we used it for .NET 1.0 version. We
are in a situation that we cannot move to ODP now. i got reply from microsoft
guys saying that it looks like an oracle bug 914652....

We are calling this compile_schema as we are droping and recreating the
table dynamically to remove the data. as a consequence the dependent packages
get invalidated...

Hope this throws some light to find way for my problem...

Thanks,
ram