Re: Is it possible to know the reason for invalid function

Hi guys,

thanks for your replies... but, ..... Lets me elaborate on my situation....

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..

On Jan 11, 11:27 am, "gazzag" <gar..._at_jamms.org> wrote:
> Raghav wrote:
> > Hi,
>
> > Is it possible to figure out the reason due to which a function is
> > invalid at any point in time ?
>
> > Kindly help.
>
> > regards
> > raghav..SQL> ALTER FUNCTION <function_name> COMPILE;
>
> Warning: Function altered with compilation errors.
>
> SQL> SHOW ERRORS
>
> or
>
> SQL> SELECT * FROM USER_ERRORS;
>
> HTH
>
> -g
Received on Thu Jan 11 2007 - 05:08:54 CST