DBMS_SHARED_POOL.KEEP dynamically ...I tried DBMS_JOB , It did not
work too.
How can I do this?
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
);
dbms_sql.close_cursor(cursor_name);
END LOOP;
END;
But , It does not execute , Is it impossible to execute
DBMS_SHARED_POOL.KEEP dynamically ...I tried DBMS_JOB , It did not
work too.
How can I do this?
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan
||''')';
dbms_output.put_line(sql_sentence);dbms_sql.parse(cursor_name,sql_sentence,
dbms_sql.native);rows_processed :=
dbms_sql.execute(cursor_name);dbms_sql.close_cursor(cursor_name);END
LOOP;END;
But , It does not execute , Is it impossible
to execute DBMS_SHARED_POOL.KEEP dynamically ...I tried DBMS_JOB
:
DBMS_SHARED_POOL.KEEP
I want to pin most run packages , I have loeded
them into a table. For this I have written ,
create or replace procedure pin_packages_defined
assql_sentence varchar2(200);cursor_name
INTEGER;rows_processed INTEGER;CURSOR tab_cur
IS SELECT owner,object_name
.
- Original Message -
From:
Mercadante, Thomas F
To: Multiple recipients of list ORACLE-L
Sent: Thursday, April 18, 2002 4:18
PM
Subject: RE: DBMS_SHARED_POOL.KEEP
Bunyamin,
Either try
removing the 'EXEC' or try putting a begin and end around the
call?
EXECUTE
DBMS_SHARED_POOL.KEEP(tab_row.owner||'.'||tab_row.object_name);
END LOOP;
-Original Message-From: Bunyamin K. Karadeniz
[mailto:[EMAIL PROTECTED]]Sent: 18 April 2002
09:28To: Multiple recipients of list ORACLE-LSubject:
DBMS_SHARED_POOL.KEEP
I want to pin most run packages , I have
: Multiple recipients of list ORACLE-LSubject:
DBMS_SHARED_POOL.KEEP
I want to pin most run packages , I have loeded
them into a table. For this I have written ,
create or replace procedure pin_packages_defined
assql_sentence varchar2(200);cursor_name
INTEGER;rows_processed