Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Package body compilation errors

user11987192Mar 18 2010 — edited Mar 18 2010
Hi all,

After running utlrp.sql, I have been left with the following invalid objects (owner: SYS Object type: PACKAGE BODY):
LT
LT_CTX_PKG
LTADM
LTDDL
LTDTRG
LTUTIL
OWM_DDL_PKG
OWM_MIG_PKG
OWM_REPUTIL
UD_TRIGS
WM_DDL_UTIL

I have tried to compile some of them individually with:

ALTER PACKAGE <pkgname> COMPILE BODY;

And I get the following error:
Warning package body altered with compilation errors.

SHOW ERRORS give me: error PL/SQL 201 Identifier WM$CONVERTDBVERSION must be declared.

Any ideas what I need to do to successfully compile the above?

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2010
Added on Mar 18 2010
3 comments
3,360 views