Re: what could the difference be?

If the function was created by user2 in user1's schema then to run it while connected as user2 you need to use user1.get_val.

Regards
David Russell

Karen Kluge wrote in message <3565DD69.EF7730FE_at_ucdavis.edu>...
>I have a mysterious occurrence I'm hoping someone can explain. I have 2
>users who both have DBA privileges, let's call them user1 and user2. If
>user1 creates a function get_val, both
>
>select get_val(100) from dual;
>
>or
>
>select user1.get_val(100) from dual;
>
>will work. However, if user2 creates the exact same function in that
>schema,
>
>select get_val(100) from dual;
>
>works, but
>
>select user2.get_val(100) from dual;
>
>results in the error
>
>ORA-06550: line 1, column 21:
>PLS-00302: component 'GET_VAL' must be declared
>
>This is true for all of user2's functions, it's not something weird
>about get_val. What can be different about the two users/schemas that
>could cause this?
>
>Thanks, Karen
>
Received on Sat May 23 1998 - 10:04:55 CDT