Re: Circular Invalid Package Issue

On Aug 6, 10:30 am, Chris S <cjsom..._at_gmail.com> wrote:
> 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.

What does DBA_DEPENDENCIES show when queried for each package?

If you compile user1's package body the only way user2's package body should go invalid is if user2's package calls user1's package.

HTH -- Mark D Powell -- Received on Wed Aug 06 2008 - 10:24:47 CDT