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 -> Error in package

Error in package

From: Jan Januska <J.Januska_at_sh.cvut.cz>
Date: Mon, 27 Apr 1998 17:40:47 +0200
Message-ID: <3544A6FE.7AB4@sh.cvut.cz>


I have following problem.
There are 2 accounts A and W.
A is owner of table A_A. This table has public synonymum and is granted to W (rights select,import,update,delete) I have SQL-script using tables owned both A (table A_A) and W. When I start this script in SQL-Plus using account W, is everethink OK ( no error message).
I also created package (under account W) containing procedure having same code as that SQL-script. By compiling this package, I get this error message:
PLS-00201: identifier 'A.A_A' must be declared

What do I wrong?
Missing some grant?

Thanks for all advices,

        Jan Januska Received on Mon Apr 27 1998 - 10:40:47 CDT

Original text of this message

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