Some time ago I ran into this problem but can not remember how to resolve. I can run a query on v$mystat fine but it will not allow my package body that queries it to compile. I get the following error. PL/SQL: ORA-00942: table or view does not exist
conn as sys grant select on v_$mystat to user_X
thanks got it!
Forum Rules
Bookmarks