Re: Help! What is wrong with this !

sjoshi_at_ingr.com wrote:
>Hello PL/SQL Gurus:
> I getting errors of the type:
>
>7/11 PLS-00201: identifier 'SYS.V$PARAMETER' must be
 declared
>7/11 PL/SQL: Item ignored
>10/19 PLS-00201: identifier 'SYS.V$SYSSTAT' must be declared
>10/19 PL/SQL: Item ignored
>
>With the following SQL when trying to run it thru. SQL/PLUS. Any
>pointers are greatly appreciated.
>thanks
>Sunit
>
>CREATE OR REPLACE PROCEDURE checkTune
>AS
>

The owner of the stored procedure needs a direct grant on the sys owned objects. As sys you can grant select on v_$parameter [notice name change] to pkg_owner; OR you can compile the procedure as sys, but if you do this it will be lost on exp/imp since sys owned objects are not exported. Also sys issued grants seem to disappear on upgrades so you might want to save the grants and run the script after running catalog and catproc on upgrades.

Note - for granting the v$ objects are generally views on synonym names and the 'real' object is named v_ (if a memory structure qualifies as real).

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Thu Jul 20 2000 - 00:00:00 CDT