OT± insert xmltype
- From: Jeroen van Sluisdam <jeroen.van.sluisdam@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 30 Jul 2004 15:18:53 +0200
Í 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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
