Hi Gurus,
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
