? have defined very simple schema
declare
doc varchar2(1000) := '
<xs:schema xmlns:xs= "http://www.w3.org/2001/XMLSchema " >
<xs:element name= "message " >
<xs:complexType >
<xs:sequence >
<xs:element name= "veld1 " type= "xs:string " maxOccurs= "unbounded "/ >
</xs:sequence >
</xs:complexType >
</xs:element >
</xs:schema >
';
begin
dbms_xmlschema.registerschema( 'http://www.oracle.com/simpletest2.xsd ', doc
);
end;
This works fine
SQL > l
1 create table simplexml(
2 id number,
3 msg sys.XMLType )
4* xmltype column msg XMLSCHEMA "http://www.oracle.com/simpletest2.xsd "
element "message "
This also works
Problem comes here
insert into simplexml (id, msg) values (1, xmltype( ' <?xml version= "1.0 " ? >
*
ERROR at line 1:
ORA-19007 (See ORA-19007.ora-code.com): Schema and element do not match
