Re: Oracle error when i use System.Data.OracleClient 1.0.5000.0

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Eric (Eric_at_nospam.com)
Date: 03/16/05 

Date: Tue, 15 Mar 2005 22:09:37 -0500

ram wrote:
> 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

Relevant Pages

  • Re: Password is not saved for Oracle connections
    ... table in SQL Server 2005. ... The package runs just fine from the BID. ... It gives a "ORA-01017: invalid username/password; logon denied" error when I use the Microsoft OLE DB Provider for Oracle, and a "ORA-10005: null password; logon denied" error when I use the Oracle provider for OLE. ...
    (microsoft.public.sqlserver.dts)
  • Re: Oracle error when i use System.Data.OracleClient 1.0.5000.0
    ... are in a situation that we cannot move to ODP now. ... and Oracle is trying to automatically recompile it. ... > that is using this package - it might not appear directly in your code. ... > I don't think this particular error has anything to do with the provider ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Release connection, OracleClient
    ... I can see the connection in Oracle remains unclosed after the package is ... As for the provider issues, I used to work with the OLEDB provider, but it ...
    (microsoft.public.sqlserver.dts)
  • Re: Packages - for real or just gimmick?
    ... You can recompile the body of the package, ... Daniel A. Morgan ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.server)
  • Re: Puzzeling error with package
    ... The platform is Oracle 10.2.0.3 running on 64bit Linux in a RAC ... I have a package which in the specification defines a constant i.e. ... All scripts spool to log files and I check each log file prior to ... initialization all happen at the same point and no errors are ...
    (comp.databases.oracle.server)