Re: Circular Invalid Package Issue

From: Mark D Powell <>
Date: Wed, 6 Aug 2008 08:24:47 -0700 (PDT)
Message-ID: <>

On Aug 6, 10:30 am, Chris S <> wrote:
> Running Oracle 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

Original text of this message