Re: xmltype column and schema validation broken on xs:choice elements
Date: Fri, 31 Oct 2008 19:48:58 +0000 (UTC)
ddf <oratune_at_msn.com> wa:
>On Oct 31, 5:26?am, Piotr Swiecicki <swieto..._at_gmail.com> wrote:
>> On Oct 31, 10:21?am, Piotr Swiecicki <swieto..._at_gmail.com> wrote:
>> > BEGIN
>> > ? DBMS_XMLSCHEMA.registerSchema(schemaURL => '/schemas/test',
>> > schemaDoc =>
>> > '<?xml version="1.0" encoding="UTF-8"?>
>> > <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
>> > ? ? ? ? ? ?elementFormDefault="qualified"
>> > ? ? ? ? ? ?attributeFormDefault="unqualified">
>> > ? <xs:annotation>
>> > ? </xs:annotation>
>> > ? <xs:element name="X">
>> > ? ? <xs:complexType>
>> > ? ? ? <xs:choice>
>> I forgot to mention - I have tried specifying the minOccurs attribute
>> explicitly (even though the specification says default value is 1)
>> <xs:choice minOccurs="1">
>> but it does not help - the behaviour is still the same
>Since you failed to report which release of Oracle you're using it's
>pretty much impossible to help you.
He mentioned it.
>Provide Oracle version (four or five numbers, NOT '9i','10g', etc) if
>you expect any assistance.
From the original post:
Piotr Swiecicki <swietopel_at_gmail.com> wa:
>Tested on Oracle versions:
>- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
>- Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit
-- "Care must be exorcised when handring Opiticar System as it is apts to be sticked by dusts and hand-fat." --Japanese Translators "Keep your fingers off the lens." --Elton Byington, English TranslatorReceived on Fri Oct 31 2008 - 14:48:58 CDT