Unable to grant execute permission on DBMS_XMLQUERY .

[vivek19]

Hi Friends
I am running on oracle 10g , while executing below command i am getting error . kindly suggest .

SQL> grant execute on DBMS_XMLQUERY to public;
grant execute on DBMS_XMLQUERY to public
*
ERROR at line 1:
ORA-01775: looping chain of synonyms
Thanks

[LKBrwn_DBA]

ORA-01775: looping chain of synonyms

[Mohith123]

Did you login as sysdba?

[Mohith123]

I think there is some problem with the package DBMS_XMLQUERY..Please execute this SQL
select * from dba_objects where object_name='DBMS_XMLQUERY' and STATUS='INVALID';

If you find it to be INVALID then that is the reason.

[vivek19]

Dear Mohith

Thanks for giving me your view which seems to be a reason for error , i would confirm that once go to office and check .
thanks