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

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 Received on Thu Feb 06 2003 - 17:23:11 CET