schemas and functions
Date: Wed, 03 Jun 1998 16:31:39 -0700
Message-ID: <3575DCDA.AA6992F9_at_ucdavis.edu>
I posted this before (see below) and realize I didn't articulate the question clearly enough.. User2 is not creating the function in User1's schema. User2 is creating the function in his/her own schema. And it's not as academic a question as it sounds: in reality I have another (non-DBA) user who wants to execute this function and can't, and I've traced the problem to the fact that for this schema, prefacing the function name with the schema name doesn't seem to work.
>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
(**I mean user2's**)
>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 Thu Jun 04 1998 - 01:31:39 CEST