Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problem executing stored function

Problem executing stored function

From: Kevin S. DeWitt <dewitt_at_interramp.com>
Date: 1997/01/27
Message-ID: <32ED58DA.7A28@interramp.com>#1/1

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  15090
Received on Mon Jan 27 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US