Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_SHARED_POOL problem
Maybe the package is created but the package body is not (the package is
valid without a package body). Check out user_objects and look for
object_name='DBMS_SHARED_POOL' and object_type='PACKAGE BODY'
Vaughan Mc Carthy wrote:
>
> Hi there
>
> I have the following error messages, when I try to execute the
> DBMS_SHARED_POOL package. I have already created the package as SYS and it
> is valid - even after I try to execute it.
>
> SQL> exec dbms_shared_pool.sizes(10);
> begin dbms_shared_pool.sizes(10); end;
> *
> ERROR at line 1:
> ORA-04068: existing state of packages has been discarded
> ORA-04067: not executed, package body "SYS.DBMS_SHARED_POOL" does not exist
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
>
> Does anybody know what the problem is and how I fix it?
>
> Regards
> Vaughan Mc Carthy
Received on Wed Sep 16 1998 - 08:40:07 CDT