Database Administration (MOSC)

MOSC Banner

PLS-00753: malformed or corrupted wrapped unit

edited May 23, 2011 5:08AM in Database Administration (MOSC) 7 commentsAnswered
 hi,  I am still working on getting the 9i import to work in the 11g database.  I have 18 packages left to make work.  None of them will complie and come up with the message.

Error(1): PLS-00753: malformed or corrupted wrapped unit.

I have tried:

"select
   'ALTER ' || OBJECT_TYPE || ' ' ||
   OWNER || '.' || OBJECT_NAME || ' COMPILE;'
from
   dba_objects
where
   status = 'INVALID'
and
   object_type in ('PACKAGE','FUNCTION','PROCEDURE')"

This came up with two tables:

"ALTER FUNCTION MDSYS.SDO_JOIN COMPILE;
ALTER FUNCTION MDSYS.SDO_PQRY COMPILE;"

It did not make any difference.


@olapimov.plb 

"select owner, object_name, object_type, status from dba_objects where

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center