Hi,
I'm trying to register an XML Schema a little differently from the default Oracle way.
Let say, I've got an element definition in my XML Schema:
<xs:element name="foobar">
<xs:complexType>
<xs:all>
<xs:element name="var_number_one" type="myVar" />
<xs:element name="var_number_two" type="myVar" minOccurs="0" />
<xs:element name="var_number_three" type="myVar" />
...
<xs:element name="var_number_onehundredfiftyone" type="myVar" minOccurs="0" />
<xs:element name="var_number_onehundredfiftytwo" type="myVar" />
</xs:all>
</xs:complexType>
</xs:element>
This gets processed by Oracle during the registration process, I use these parameters for registerSchema:
LOCAL => TRUE, -- local
GENTYPES => TRUE, -- generate object types
GENBEAN => FALSE, -- no java beans
GENTABLES => TRUE, -- generate object tables
FORCE => FALSE,
OPTIONS => DBMS_XMLSCHEMA.REGISTER_AUTO_OOL
The result is that each element gets the following attributes:
oraxdb:propNumber="4986"
oraxdb:global="false"
oraxdb:SQLName="var_number_one"
SQLType="var_number_one928_T"
oraxdb:SQLSchema="SYSTEM"
oraxdb:memType="258"
oraxdb:MemInline="false"
oraxdb:SQLInline="true" oraxdb:JavaInline="false"
which means that each element (var_number_*) is like an SQL Object column in the foobar table... right?
Here is what I would like to try, if it is possible at all:
I want the name of the element to be a varchar property/column of each row in the foobar table.
The image attached illustrates the current and target situation.
Is it possible to do this by influencing the XML Schema without changing the original xml format, using the oraxdb attributes? Or is their another solution?
[Updated on: Thu, 21 August 2008 08:04]
Report message to a moderator