xdb:tableProps and Varray within a Varray
Hello.
I am trying to use xdb:tableProps attribute to set the names of the ordered collection tables created for the varrays.
This works for arrays that are within a non-repeating element, but not for arrays who themselves are within arrays.
<xs:element name="Schema1" type="Schema1_type" xdb:defaultTable="SCHEMA1"
xdb:tableProps="VARRAY XMLDATA.A1 STORE AS TABLE SCHEMA1_A1
VARRAY XMLDATA.A1.A2 STORE AS TABLE SCHEMA1_A1_A2"/>
<xs:complexType name="Schema1_type" xdb:SQLType="SCHEMA1_T">
<xs:sequence>
<xs:element name="A1" type="A1_type" minOccurs="0" maxOccurs="unbounded" xdb:SQLName="A1" xdb:SQLCollType="S1_A1T_A1_C"/>
</xs:sequence>
</xs:complexType>
<xs:complexType name="A1_type" xdb:SQLType="S1_A1_T" >
<xs:sequence>
<xs:element name="A1" type="Integer_type" xdb:SQLName="A1" xdb:SQLType="INTEGER"/>
<xs:element name="A2" type="A2_type" minOccurs="0" maxOccurs="unbounded" xdb:SQLName="A2" xdb:SQLCollType="S1_A1T_A2_C"/>
</xs:sequence>
</xs:complexType>
<xs:complexType name="A2_type" xdb:SQLType="S1_A1_A2_T">
<xs:sequence>
<xs:element name="A1" type="String_type" xdb:SQLName="A1" xdb:SQLType="VARCHAR2"/>
</xs:sequence>
</xs:complexType>
The A1 varray can be referred to in the tableProps as ' VARRAY "XMLDATA"."A1" STORE AS TABLE ....'
But I can't figure out how to refere to the A2 varray stored inside the A1 varray , So far I have tried
"XMLDATA"."A1"."A2"
"XMLDATA"."A2"
"A2"
"A1"."A2"
but I either get "ORA-22809: nonexistent attribute", or "ORA-00904: : invalid identifier".