Unable to grant execute permission on DBMS_XMLQUERY .
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
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
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.
Thanks for giving me your view which seems to be a reason for error , i would confirm that once go to office and check .
Last edited by vivek19; 05-10-2008 at 02:03 AM.
Click Here to Expand Forum to Full Width