Database Software

Hi,

My oracle version is 10.2.0.2.0. Following this suggest :

http://forums.oracle.com/forums/thread.jspa?messageID=835251&#835251

I tried to create a schema in this way:

<?xml version="1.0"?>
<xs:schema 
	xmlns:xs="http://www.w3.org/2001/XMLSchema"
	xmlns:xdb="http://xmlns.oracle.com/xdb"
	targetNamespace="http://test.example.it/test"
	xmlns="http://test.example.it/test"
	elementFormDefault="qualified"
	attributeFormDefault="unqualified">
	
	<!-- definition of main element -->
	<xs:element name="Project">
		<xs:complexType>
			<xs:sequence>
				<xs:element name="AnnoBando" type="xs:string" xdb:SQLType="CLOB"/>
				<xs:element name="AnnoBando2" type="xs:string"/>
			</xs:sequence>
		</xs:complexType>
	</xs:element>
	
</xs:schema>

In this schema only element "AnnoBando" contains XHTML elements, my question is, when I upload my xml document, can I pass directly XHTML elements in this way?

insert into TESTSQLTYPE values ('codice', xmltype('
<Project
	xmlns = "http://test.example.it/test"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:xml="http://www.w3.org/XML/1998/namespace"
	xsi:schemaLocation = "http://test.example.it/test http://test.example.it/test2.xsd">
	
	<AnnoBando> text <b>bolded text</b> text</AnnoBando>
  <AnnoBando2>empty text</AnnoBando2>
</Project>
'))

or I should insert html entities of "<" and ">" of the element?
If i try to insert the xml example specified here I get this error:

ORA-31187: Cannot Add Node 'b' (type='element') to Simple Type Node '/Project/Annobando'

Thanks for your help.

Stefano