0 Replies Latest reply on Jun 27, 2019 3:51 AM by Swaminathan

    Error while registering a xsd schema

    Swaminathan

      Dear all,

      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

       

      DECLARE

      a clob;

      BEGIN

      SELECT xsd_col_value INTO A FROM tmp_poc_uncompress WHERE seq_no = 1;

         dbms_xmlschema.registerSchema('test.xsd',a );

      END;

      Error report:

      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

       

      Thanks.

      Swaminathan