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;
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:
:= . ( @ % ;
expecting one of the following:
:= . ( @ % ;
tia
Ramon E.
Estevez
809-565-3121
