PLS-00201: identifier 'DBMS_SHARED_POOL.KEEP' must be declared
cayenneSep 2 2010 — edited Sep 2 2010Hi all,
I've seen this before, but can't remember what I did to get it to work.
I've imported schemas into a new database instance.
schema X has a package body that won't compile. I had a problem in that I had to grant the user explicitly 'select on dba_objects' to get rid of one problem (he could desc the table, but guessing package couldn't with the role...so granted it explicitly)
Last problem, however, seems it can't compile due to some priv problem with the DBMS_SHARED_POOL procedure.
I've looked around, and have made sure to run the @$ORACLE_HOME/rdbms/admin/dbmspool.sql to ensure the package is there.
I've granted user X execute on DBMS_SHARED_POOL, which says grant successful.
Yet..I still keep getting the PLS-00201 errors...
Any ideas?
Thanks in advance,
cayenne