Circular Invalid Package Issue
From: Chris S <cjsommer_at_gmail.com>
Date: Wed, 6 Aug 2008 07:30:10 -0700 (PDT)
Message-ID: <c0104d56-20dc-4d0e-8ca9-7d39b05414fd@25g2000hsx.googlegroups.com>
Date: Wed, 6 Aug 2008 07:30:10 -0700 (PDT)
Message-ID: <c0104d56-20dc-4d0e-8ca9-7d39b05414fd@25g2000hsx.googlegroups.com>
Running Oracle 10.2.0.3 on RHEL
Here is my problem:
I have a package in a user schema (USER1) that reads data through a user (not global) DBLINK. I have another user schema (USER2) with the same package that reads the same data over its own user DBLINK.
When I compile USER1's package body it invalidates USER2's package body. When I compile USER2's package body, it invalidates USER1's package body.
It is compiling at runtime (lazy compiles) just fine so it has not been an issue for me to this point. I was just wondering why it would invalidate the other packages when I am not making any modifications to the remote object. Received on Wed Aug 06 2008 - 09:30:10 CDT