|
-
I wont get this error if I make script as below is it?
declare
own varchar2(100);
nam varchar2(100);
cursor pkgs is
select owner, object_name
from dba_objects
where owner='SYS';
begin
open pkgs;
loop
fetch pkgs into own, nam;
exit when pkgs%notfound;
sys.dbms_shared_pool.keep(own || '.' || nam, 'P');
end loop;
end;
Please reply.....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|