Re: Error pinning PKS in shared pool

[Waleed Khedr]

Title: Message

You do not need 'exec immediate' ----- Original Message ----- From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Sunday, February 23, 2003 2:58 PM 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