Am trying to load an xsd in the database and validate it against the corresponding xml.
Have loaded the xsd in the xsd_col_value. I am trying to use this for registering the xsd schema.
I googled and found that i should have "Alter session", executed privilege on DBMS_XDBZ, "XDBADMIN" role provided to get rid of this error. The below code works fine with the option - enablehierarchy set as DBMS_XMLSCHEMA.enable_hierarchy_none. But when I try to enable it using enablehierarchy => DBMS_XMLSCHEMA. ENABLE_HIERARCHY_CONTENTS, am getting the below error.
Kindly provide your suggestions
SELECT xsd_col_value INTO A FROM tmp_poc_uncompress WHERE seq_no = 1;
ORA-31061: XDB error: DBMS_XDBZ.ENABLE_HIERARCHY
ORA-06512: at "XDB.DBMS_XDBZ0", line 131
ORA-06512: at "XDB.DBMS_XDBZ0", line 588
ORA-01031: insufficient privileges
ORA-06512: at "XDB.DBMS_XDBZ", line 37
ORA-06512: at line 1
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 72
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 33
ORA-06512: at line 5