dbms_shared_pool package

[kris123]

Hi Friends,

In my apps schema I found a package named DBMS_SHARED_POOL
with an INVALID status. I tried recompiling it using...

SQL> ALTER PACKAGE DBMS_SHARED_POOL COMPILE;
Warning: Packaged altered with compilation errors.

SQL> show errors
No errors.

Is there other way to display package compilation errors?

Another packaged named VALIDATE_ACCNT with invalid status, which
when compiled successfully, generates or will make other functions
and procedures invalid.

Any comments will be highly appreciated.

[gbrabham]

select text from all_errors where name = 'DBMS_SHARED_POOL';

Hope this helps
Gregg

[pando]

that's sys packages, what are you doing with it under APPS :?

[kris123]

Thanks friends,

I just don't know why is it there, maybe our 3rd-party apps needed this dbms_shared_package. Should I transfer it to SYS schema?

Any comments on why compiling a certain package (successfully)
turns other functions and procedures INVALID.