Home » Developer & Programmer » JDeveloper, Java & XML » Register XML Schema -> XMLTypes (Oracle 11, XML DB)
icon5.gif  Register XML Schema -> XMLTypes [message #342131] Thu, 21 August 2008 08:02
ljpeters
Messages: 1
Registered: August 2008
Junior Member
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

Previous Topic: Predictive Model Markup Language (PMML) datafile location
Next Topic: Passing xml string to PL/SQL from JSP
Goto Forum:
  


Current Time: Fri Mar 29 03:55:02 CDT 2024