Pinning Packages in the Shared Pool

Has anyone successfully pinned a package into the shared pool ?

It is mentioned briefly in the documentation, but does not outline how to do it. I did find the dbms_shared_pool package supplied by Oracle though. (Very little documentation on this)
It has a procedure called "keep" that should do the job but I cannot get it to work.

Example follows:

16:15:54 SQL+> begin
16:15:54   2          dbms_shared_pool.keep('HUSD2.PG_SEC_ADMIN');
16:15:54   3  end;
16:15:54   4  /

ORA-06564: object HUSD2.PG_SEC_ADMIN does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 28
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 17
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 24
ORA-06512: at line 2

For some reason my package cannot be found. I have tried a few permutations of running this as system or the package owner.

Am I doing something wrong?
Is there another way to pin objects?

We are using 7.1.3 on HP-UX.

Thanks
Tony Cook Received on Thu Feb 23 1995 - 00:56:20 CET