ORA-04043 error after applying the patches

[msuresh]

Hi,
I applied the patchset 8.1.7.2 on 8.1.7.0 in solaris anf after that i recompiled some of the invalid objects.But i was unable to recompile a function NameFromLastDDL of sys schema.

When i tried to recompile this function,it is giving me a error ORA-04043 object does not exist.When i tried to drop this function ,then also the same error message.

I queried the dba_objects and found the name of the object as typed above not all the charachers in upper case was found as invalid.What to do now?.

Pls. help me

Thanks

[marist89]

alter function "NameFromLastDDL" compile

or, you can use the utlrp.sql script from $OH/rdbms/admin

[msuresh]

alter function "NameFromLastDDL" compile

Yes This Worked ....Thanks a lot...