-
Unable to grant execute permission on DBMS_XMLQUERY .
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
-
"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.
-
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
Last edited by vivek19; 05-10-2008 at 01:03 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|