FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJun 15, '11 at 5:56p
activeJun 15, '11 at 5:56p
posts1
users1
websiteoracle.com

1 user in discussion

Nagaraj S: 1 post

People

Translate

site design / logo © 2022 Grokbase