Re: Circular Invalid Package Issue
Date: Wed, 6 Aug 2008 08:24:47 -0700 (PDT)
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