Re: Problem with functions getting invalidated

Raghav wrote:
> Hi guys,
>
> I have three databases...
>
> A, B, C
>
> A has two schema a1 and a2.
>
> a1 is my test environment and has synonyms to B (using db links)
>
> a2 is my dev environment and has synonyms to C (using db links)
>
> the problem that i am facing is...
>
> when i compile function f1 in a1 it compiles fine, but the function in
> f2 becomes invalid. The same is true vice versa. i.e. I compile f1 in
> a2 and its fine, but f1 in a1 becomes invalid.
>
> since there are no errors at the time of compilation, your suggestions
> cannot really be THE solution to situation. What I look for is, for
> what reason the other schema's f1 gets invalidated. I believe the
> oracle metadata stores that kind of info.
>
> Looking forward to your responses...
>
> regards
> raghav..

And the version number is?

Seems that your functions have dependencies that reference the link. You might want to replace them with local synonyms.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org