RE: Error pinning PKS in shared pool

[Richard Ji]

Title: Message

remove exec immediate.

 

Richard

-----Original Message-----
From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 23, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L
Subject: Error pinning PKS in shared pool

Sorry, new DB and hadn't execute the Dbmspool.sql script.

 

CREATE OR REPLACE TRIGGER PAQUETES_MEMORIA
    AFTER STARTUP ON DATABASE
  BEGIN
     exec immediate dbms_shared_pool.keep('DBMS_ALERT');
     exec immediate dbms_shared_pool.keep('DBMS_DDL');
     exec immediate dbms_shared_pool.keep('DBMS_DESCRIBE');
     exec immediate dbms_shared_pool.keep('DBMS_LOCK');
     exec immediate dbms_shared_pool.keep('DBMS_OUTPUT');
     exec immediate dbms_shared_pool.keep('DBMS_PIPE');
     exec immediate dbms_shared_pool.keep('DBMS_SESSION');
     exec immediate dbms_shared_pool.keep('DBMS_SHARED_POOL');
     exec immediate dbms_shared_pool.keep('DBMS_STANDARD');
     exec immediate dbms_shared_pool.keep('DBMS_UTILITY');
     exec immediate dbms_shared_pool.keep('STANDARD');
     exec immediate dbms_shared_pool.keep('BUSCA_SECUENCIA');
END;

 

I am getting this error, tried with users SYS and SYSTEM

 

12/11    PLS-00103: Encountered the symbol "DBMS_SHARED_POOL" when
         expecting one of the following:
         := . ( @ % ;

tia

 

 

Ramon E. Estevez

[EMAIL PROTECTED]

809-565-3121