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

From: william milbratz <milbratz_at_hotmail.com>
Date: 7 Feb 2003 17:06:46 -0800
Message-ID: <cee3515e.0302071706.1c706cb1_at_posting.google.com>

> Are you by chance the owner fo the tables in 9i?
Yes. both in the 8i and 9i database I ("I, Schema") own the tables and the functions.

> Do a direct grant, not thru a role.
Granting execute and all on the function has no effect.

any other suggestions? has anyone else seen this?

bill m Received on Sat Feb 08 2003 - 02:06:46 CET

This message: [ Message body ]
Next message: P. van der Ven: "Re: ORA-00904 when selecting from database link"
Previous message: Larry: "Re: Clone a database to another server using RMAN on Windows 2000"
Maybe in reply to: william milbratz: "PLS-00222: stored procedure's "select" calls a user-defined function"
In reply to Frank: "Re: PLS-00222: stored procedure's "select" calls a user-defined function"
Next in thread: Frank: "Re: PLS-00222: stored procedure's "select" calls a user-defined function"
Reply: Frank: "Re: PLS-00222: stored procedure's "select" calls a user-defined function"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message