Re: error pinning a package

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 10 Aug 2004 07:30:22 +1000
Message-ID: <opschh0wru3d8uqx@shostakovich.dizwell.com>

On 9 Aug 2004 13:40:02 -0700, Thomas <manojthomas_at_gmail.com> wrote:

> 13:38:39 SQL> show user
> USER is "SYS"
> 13:38:50 SQL> execute dbms_shared_pool.keep('SYS.STANDARD','P');
> BEGIN dbms_shared_pool.keep('SYS.STANDARD','P'); END;
>
> *
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00201: identifier 'DBMS_SHARED_POOL.KEEP' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
>
> Elapsed: 00:00:00.00

Try running catspool.sql first. Found in the usual place: Oracle_Home, rdbms, admin.

Needed to create DBMS_SHARED_POOL.

Regards
HJR Received on Mon Aug 09 2004 - 16:30:22 CDT