Re: PLS-00222: stored procedure's "select" calls a user-defined function

william milbratz wrote:
> I should clarify that this isn't a privilege issue: I've granted all
> privileges (dba) to my schema owner (it's a dev environment). (Plus
> the schema-owner is calling his/her/its own function so privileges
> shouldn't be an issue).
>
> I also subsequently granted explicitly 'execute' and 'all' privileges
> on the function to the schema owner and to public.
>
> Additionally I tried jiggering the authid privilege on the function as
> someone suggested this. This had no impact (as I expected).
>
> The problem seems that the 8.1.7 plsql compiler isn't searching the
> current namespace for function definitions: it only looks for system
> defined functions. The same statement in sqlplus executes fine...
>
> bill m

DBA is a role - roles aren't active in PL/SQL. Are you by chance the owner fo the tables in 9i?

Do a direct grant, not thru a role.

Frank Received on Thu Feb 06 2003 - 19:34:11 CET