RE: Error pinning PKS in shared pool

[John Clarke]

Title: Message

You can take out the “exec immediate”, I believe.   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ramon E. Estevez 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