OT± insert xmltype

Í 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: Schema and element do not match


SQL> l
1 insert into simplexml (id, msg) values (1, xmltype('<?xml version="1.0" ?>
2 <xs:message
3 xmlns:xs="http://www.oracle.com/simpletest2.xsd";
4 xmlns:xsi="http://www.w3.org/2001/XMLSchema";
5 xsi:schemaLocation="http://www.oracle.com/simpletest2.xsd";>
6 <veld1>"test"</veld1>
7 </xs:message>
8* '))
SQL> 

What is wrong, please help this gives me a headache

Tnx,

Jeroen 
 
 
P.S. Any other forums besides otn known about xml and oracle !
 

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: