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
Messages: 1
Registered: August 2008
Junior Member

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: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" />

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,

The result is that each element gets the following attributes:
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: Sun Oct 23 13:00:15 CDT 2016

Total time taken to generate the page: 0.09198 seconds