DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Unable to grant execute permission on DBMS_XMLQUERY .

  1. #1
    Join Date
    May 2008
    Posts
    4

    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

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Apr 2008
    Location
    Bangalore
    Posts
    96
    Did you login as sysdba?

  4. #4
    Join Date
    Apr 2008
    Location
    Bangalore
    Posts
    96
    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.

  5. #5
    Join Date
    May 2008
    Posts
    4
    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
  •  


Click Here to Expand Forum to Full Width