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)
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)