Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

xdb:tableProps and Varray within a Varray

784379Jul 12 2010
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".
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2010
Added on Jul 12 2010
0 comments
598 views