Hi,
I'm using Oracle 11g release 1. I tried to registered following XML schema:
BEGIN
DBMS_XMLSCHEMA.REGISTERSCHEMA(
schemaurl => 'jh_studenti_bin.xsd',
schemadoc => '
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
<xs:element name="studenti">
<xs:complexType>
<xs:sequence>
<xs:element name="student" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="jmeno" type="xs:string"/>
<xs:element name="prijmeni" type="xs:string"/>
<xs:element name="fakulta">
<xs:simpleType><xs:restriction base="xs:string"><xs:enumeration value="FAV"/><xs:enumeration value="FEK"/><xs:enumeration value="FEL"/></xs:restriction></xs:simpleType>
</xs:element>
</xs:sequence>
<xs:attribute name="osobni_cislo" type="xs:nonNegativeInteger" use="required"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
<xs:unique name="unikatni_osobni_cislo">
<xs:selector xpath="student"/>
<xs:field xpath="@osobni_cislo"/>
</xs:unique>
</xs:element>
</xs:schema>',
local => TRUE,
gentypes => FALSE,
genbean => FALSE,
gentables => TRUE,
force => FALSE,
owner => 'INSTALL2',
OPTIONS => DBMS_XMLSCHEMA.REGISTER_BINARYXML);
END;
then I tried to insert a file into a table based on this schema (Binary). My file look like this:
<?xml version="1.0" encoding="cp1250"?>
<studenti>
<student osobni_cislo="1">
<jmeno>Martin</jmeno>
<prijmeni>Červený</prijmeni>
<fakulta>FAV</fakulta>
<predmet>
<predmet_nazev>Obecná ekonomická teorie</predmet_nazev>
<predmet_zkratka>KEF/DOET</predmet_zkratka>
<predmet_znamka>2</predmet_znamka>
</predmet>
</student>
</studenti>
eventually I got:
java.sql.SQLException: ORA-31011: Selhala syntaktická analýza XML (sorry for czech sentece)
ORA-19202: Vyskytla se chyba při zpracování XML
LSX-00213: only 0 occurrences of particle "student", minimum is 1
Do you have any ideas why it's not working?
Thanks
Jan Hruby