Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Problem executing stored function
Thanks for taking the time to read this.
I have a stored function created by user A that works fine for user A. However, user B cannot 'see' this function from his SELECT. User A granted EXECUTE privileges to a global role that all users belong to. User A also created a PUBLIC synonym for the stored function. An example follows:
SELECT qty_of_trading_instr_executed(100) FROM DUAL;
User A returns the correct value. User B gets:
PLS-00201: identifier 'QTY_OF_TRADING_INSTR_EXECUTED' must be declared
I've also tried prefacing the function name with the schema name. Any ideas as to what I'm doing wrong? BTW, I'm using Oracle 7.1.3 and PL/SQL 2.1.3. Thanks
-- Kevin S. DeWitt Actium dewitt_at_interramp.com 101 North Meadows Dr 1-888-504-8048 x5006 Suite 113 http://www.actium.com Wexford, PA 15090Received on Mon Jan 27 1997 - 00:00:00 CST
![]() |
![]() |