1 2 Previous Next 18 Replies Latest reply: Aug 13, 2013 3:38 AM by 946212 Go to original post RSS
      • 15. Re: XDB is invalid post registering schema
        946212

        ok  made the change to the local repos like:

         

         

        <?xml version='1.0'?>

        <!DOCTYPE xs:schema PUBLIC "-/XML_SCHEMA/EGISPROD" "XMLSchema.dtd" >

         

         

        now i get this error?

         

         

        SQL> declare

          2  v_result boolean;

          3  v_schema xmltype := xmltype(bfilename('XML_VALIDATION', 'xml.xsd'), nls_cha

        rset_id('UTF8'));

          4  begin

          5  v_result := dbms_xdb.CreateResource('/XML_SCHEMA/EGISPROD/xml.xsd', v_schem

        a);

          6  end;

          7  /

        declare

        *

        ERROR at line 1:

        ORA-31001: Invalid resource handle or path name "/XMLSchema.dtd"

        ORA-06512: at "SYS.XMLTYPE", line 296

        ORA-06512: at line 3

        • 16. Re: XDB is invalid post registering schema
          odie_63

          You must change the location, not the PUBLIC ID...

          <!DOCTYPE xs:schema PUBLIC "-//W3C//DTD XMLSCHEMA 200102//EN" "/XML_SCHEMA/EGISPROD/XMLSchema.dtd" >
          • 17. Re: XDB is invalid post registering schema
            946212

            thanks, that worked Odie

             

             

            now have this problem?

             

             

            SQL>  declare

              2  v_result boolean;

              3  v_schema xmltype := xmltype(bfilename('XML_VALIDATION', 'xml.xsd'), nls_cha

            rset_id('UTF8'));

              4  begin

              5  v_result := dbms_xdb.CreateResource('/XML_SCHEMA/EGISPROD/xml.xsd', v_schem

            a);

              6  end;

              7  /

             

             

            PL/SQL procedure successfully completed.

             

             

            SQL>

             

             

            SQL> begin

              2  dbms_xmlschema.registerSchema(

              3  schemaURL => 'xml.xsd',

              4  schemaDoc => xdburitype('/XML_SCHEMA/EGISPROD/xml.xsd').getXML(),

              5  local => true,

              6  genTypes => true,

              7  genbean => false,

              8  genTables => true

              9  );

            10  end;

            11  /

            begin

            *

            ERROR at line 1:

            ORA-31011: XML parsing failed

            ORA-19202: Error occurred in XML processing

            LPX-00107: Warning: element "xs:simpleType" has multiple declarations

            Error at line 204

            Error at line 107

            Error at line 95

            ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 55

            ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 159

            ORA-06512: at line 2

             

            extract from xml.xsd             

             

             

             

            <xs:attribute name="space" default="preserve">

              <xs:simpleType>

               <xs:restriction base="xs:NCName">

                <xs:enumeration value="default"/>

                <xs:enumeration value="preserve"/>

               </xs:restriction>

              </xs:simpleType>

            </xs:attribute>

            • 18. Re: XDB is invalid post registering schema
              946212

              Hi, any suggestions? Regards, Nick

              1 2 Previous Next