OWA_UTIL Package invalid

I am getting below package as invalid in 10.2.0.1 version. I tried to run utlrp and tried to compile the package but still it remains invalid. Please help me on how to make it valid.

SQL> select object_name,object_type,owner from dba_objects where status='INVALID';

OBJECT_NAM OBJECT_TYPE OWNER

• ------------------- ------------------------------

OWA_UTIL PACKAGE BODY SYS SQL> alter PACKAGE SYS.OWA_UTIL COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> show error;

Errors for PACKAGE BODY SYS.OWA_UTIL:

  PLS-00306: wrong number or types of arguments in call to

       'GET_SYNONYM_DEFN' 2403/7 PL/SQL: Statement ignored

2403/7 PLS-00307: too many declarations of 'NAME_RESOLVE' match this

       call

-Naga

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 15 2011 - 12:56:12 CDT