what could the difference be?

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 Fri May 22 1998 - 15:17:45 CDT