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;