Skip to content

How to Resolve PLS-00753: malformed or corrupted wrapped unit

  • by

PLS-00753

Found a compile error PLS-00753 when we compiled trigger CAT_ROLLBACK_TRIGGER owned by GSMADMIN_INTERNAL.

PLS-00753: malformed or corrupted wrapped unit

Finally, we found that some common packages are not accessible by PUBLIC, especially the package UTL_FILE.

Solution

So the solution is to grant those package to public again.

GRANT EXECUTE ON SYS.UTL_FILE TO PUBLIC;

For safety, we should additionally re-grant the required privileges to PUBLIC, too.

GRANT EXECUTE ON SYS.DBMS_RANDOM TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_HTTP TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_SMTP TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_TCP TO PUBLIC;

They should be enough to pass the compilation.

There're more packages owned by SYS should be granted to PUBLIC to execute.

Leave a Reply

Your email address will not be published.