ORA-19046 when trying to create xmltype table against recursive schema
Under Oracle 11g Standard Edition release 11.2.0.2.0 (64-bit), when trying to use an example of a recursive xml schema from the XML DB Developer's Guide (Version 11g Release 2, Example 9-20) the schema appears to register correctly:
begin
dbms_xmlschema.registerschema(
schemaurl => 'test.xsd',
schemadoc => '<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:xdb="http://xmlns.oracle.com/xdb"
elementFormDefault="qualified" attributeFormDefault="unqualified">
<xs:element name="person" type="personType" xdb:defaultTable="PERSON_TABLE"/>
<xs:complexType name="personType" xdb:SQLType="PERSON_T">
<xs:sequence>
<xs:element name="descendant" type="personType" minOccurs="0"
maxOccurs="unbounded" xdb:SQLName="DESCENDANT"