Pinning Package Problem...

From: Tim T Ketchum <tketchum_at_oregon.uoregon.edu>
Date: 1996/12/20
Message-ID: <tketchum-2012961558430001@d32-171.uoregon.edu>#1/1

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 Fri Dec 20 1996 - 00:00:00 CST