DBMS_SHARED_POOL installation

From: <lalaina_at_my-dejanews.com>
Date: Mon, 17 Aug 1998 09:16:47 GMT
Message-ID: <6r8sdu$upj$1@nnrp1.dejanews.com>

Hello ORACLE guys ,

I'm currently working on a heavy application that would need the use of DBMS_SHARED_POOL.KEEP package.

But when I run the script prvtpool.plb (as described in the docs) , I receive error messages :

-ORA-01933: cannot create a stored object using privileges from a role

-LINE/COL ERROR

--------------------------------------------------------- 21/7 PL/SQL: SQL Statement ignored 21/48 PLS-00201: identifier 'X$KGLOB' must be declared 67/9 PL/SQL: SQL Statement ignored 72/14 PLS-00201: identifier 'SYS.V_$SQLAREA' must be declared 89/7 PL/SQL: Statement ignored 89/10 PLS-00364: loop index variable 'REC' use is invalid

Does anyone know how can I solve those problems ?

Many thanks in advance

Lalaina
Lalaina.rako_at_advalvas.be

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 17 1998 - 04:16:47 CDT