Re: Pinning Package Problem...

I'm fairly sure you have to have the package in memory FIRST, hence it does exists when you pin it. If necessary, write a simple public procedure that just returns, execute it (which loads the package, then pin it.

Russ russ.eberle_at_born.com

tketchum_at_oregon.uoregon.edu (Tim T Ketchum) wrote:

>I've been pinning a variety of packages in hopes of improving the
>performance of my Oracle Webserver 2.0. Most of the packages I attempted
>worked fine. Oddly enough, when I tried to pin the main OWA package it
>would fail.
 

>The statement looks like :

>---------------------
 

>>execute dbms_shared_pool.keep('username.OWA');
>begin dbms_shared_pool.keep('username.OWA'); end;
 

>*
>ERROR at line 1:
>ORA-06564: object username.OWA does not exist
>ORA-06512: at "SYS.DBMS_UTILITY", line 28
>ORA-06512: at "SYS.DBMS_SHARED_POOL", line 19
>ORA-06512: at "SYS.DBMS_SHARED_POOL", line 26
>ORA-06512: at line 1
 

>---------------
 

>However, I can recompile it with no problem:
 

>> alter package username.OWA COMPILE PACKAGE;
 

>Package altered.

>Anyone have any ideas why this would be?
 

>tketchum
Received on Sat Dec 21 1996 - 00:00:00 CST