Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Error in package
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
![]() |
![]() |