Skip to Main Content

APEX

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!

PLS-00753: malformed or corrupted wrapped unit

Jules VerhoevenJan 28 2009 — edited Feb 7 2009
Hi,
After changing the ip adress on the server, we had some problems with starting up opmnct.
After changing the host file this could be started up again.
Now apex does not work for some reason
I found invalid objects in the database and when I recompiled I get PLS-00753: malformed or corrupted wrapped unit

I found some thread where people advice to reinstall apex

I did an upgrade from 3.1.1 to 3.1.2 with patch p7313609_111060_GENERIC.zip
But still no solution
Errors are
86/5 PL/SQL: Statement ignored
86/5 PLS-00201: identifier 'SYS.WWV_DBMS_SQL' must be declared

Recompile does not work


We found in metalink a case where is told not to compile remotly with toad but execute the script localy with sqlplus.
We tried that but this does not help.

Is there a way to reinstall apex without loosing the applications that I created?

Reinstalling apex (remove script and than install again) drops the FLOWXX schema I suppose...

Regards Jules
This post has been answered by Tyler-Oracle on Jan 30 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2009
Added on Jan 28 2009
20 comments
14,893 views