Grant Priviledge on XML objects.

[tekpr00]

Hello All,

Our user is getting the following error while using the XML object.

p_xml := SYS.XMLTYPE.createxml(que_message.payload); “

She was getting the following error;
Error ORA-00604: error occurred at recursive SQL level 3
ORA-00942: table or view does not exist

From experience, table or view does not exist error usually is a permission problem. Most likely the sys.createxml is where the permission problem is.

how will I grant privileges on sys.createxml to user - dbdevlpr ( for example)

 

[tekpr00]

I just found put that the object does not exist at all:
SQL> grant all on sys.createxml to vsdevl;
grant all on sys.createxml to vsdevl
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> desc sys.createxml;
ERROR:
ORA-04043: object sys.createxml does not exist

 

[tekpr00]

How do I create this package sys.createxml

 

[Turkbear]

Hi,
This may help:

http://www.oracle.com/technetwork/articles/quinlan-xml-095823.html

Be sure that the full XML DB component has been installed.





To Paraphrase:"The Help you get is proportional to the Help you give.."