Home » Developer & Programmer » JDeveloper, Java & XML » How to create xml from database using standard xmlsheema  () 1 Vote
How to create xml from database using standard xmlsheema [message #259937] Thu, 16 August 2007 21:20
monriz
Messages: 1
Registered: August 2007
Location: CANADA
Junior Member

Hi there
I have xml standard scheema xsd , i want to create xml generated data from oracle database tables, and those tables colums should be shown according to the xml scheema .
Please can any one solve my problem.

Please cut and paste followinf sceema into .xsd file..

<?xml version="1.0" encoding="UTF-8"?>
<!--This is the CGI RATABASE XML GENERIC ADAPTER XML Schema. This file is based upon RBGENERIC DTD version 2.1 02/03/2003 12:00PM
History:
Version 1.0 Generated on: Tue June 21 13:44:22 EST 2003
Version 1.1 : Mon May 24
Modification: Add default for -INITACCV
-ITEMSEQDES
-ITEMMATCHDES
Version 3.0 February
Modification: Add RATEREQUESTEXT node

COPYRIGHT 2001, CGI INFORMATION SYSTEMS AND MANAGEMENT CONSULTANTS, INC., PROPRIETARY AND CONFIDENTIAL.

http://www.cgi.com-->
<xs:schema xmlns:rb="http://www.cgi.com/Ratabase" xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.cgi.com/Ratabase" elementFormDefault="qualified" version="2.1">
<xs:simpleType name="C-1">
<xs:restriction base="xs:string">
<xs:maxLength value="1"/>
<xs:minLength value="0"/>
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="C-31">
<xs:restriction base="xs:string">
<xs:maxLength value="31"/>
<xs:minLength value="0"/>
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="C-32">
<xs:restriction base="xs:string">
<xs:maxLength value="32"/>
<xs:minLength value="0"/>
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="C-128">
<xs:restriction base="xs:string">
<xs:maxLength value="128"/>
<xs:minLength value="0"/>
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="C-256">
<xs:restriction base="xs:string">
<xs:maxLength value="256"/>
<xs:minLength value="0"/>
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="NMType">
<xs:restriction base="xs:string">
<xs:maxLength value="32"/>
<xs:minLength value="1"/>
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="IndicatorType">
<xs:restriction base="xs:string">
<xs:enumeration value="YES"/>
<xs:enumeration value="NO"/>
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="RBXMLType">
<xs:restriction base="xs:string">
<xs:enumeration value="SPECIFIC"/>
<xs:enumeration value="GENERIC"/>
</xs:restriction>
</xs:simpleType>
<xs:attributeGroup name="ControlAttributes">
<xs:attribute name="ACTIVE" type="xs:string"/>
<xs:attribute name="TYPE" type="xs:string"/>
<xs:attribute name="ORIGIDX" type="xs:string"/>
<xs:attribute name="CURRENTIDX" type="xs:string"/>
<xs:attribute name="EXCLUDE" type="xs:string"/>
</xs:attributeGroup>
<xs:attributeGroup name="StatusAttributes">
<xs:attribute name="ACTIVE" type="xs:string"/>
<xs:attribute name="TYPE" type="xs:string"/>
</xs:attributeGroup>
<xs:element name="FLD">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="NM" type="rb:NMType" use="required"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="DATABASENAME" type="rb:C-32"/>
<xs:element name="DATABASEPW" type="rb:C-32"/>
<xs:element name="DATABASESOURCE" type="rb:C-128"/>
<xs:element name="DATABASEPRVDR" type="rb:C-128"/>
<xs:element name="USERNAME" type="rb:C-32"/>
<xs:element name="SEVERITYDES" type="xs:integer" default="4"/>
<xs:element name="CALLDES" type="rb:C-1"/>
<xs:element name="INITACCDES" type="rb:C-1"/>
<xs:element name="INITACCV" type="xs:integer" default="0"/>
<xs:element name="ITEMSEQDES" type="xs:integer" default="2"/>
<xs:element name="ITEMMATCHDES" type="xs:integer" default="2"/>
<xs:element name="CENTURYDES" type="xs:string"/>
<xs:element name="DATEDES" type="xs:string"/>
<xs:element name="FORMULADES" type="xs:string"/>
<xs:element name="STRINGDES" type="xs:string"/>
<xs:element name="VALIDATIONDES" type="rb:C-1"/>
<xs:element name="STEPSDES" type="rb:C-1" default="N"/>
<xs:element name="RETINFONUM" type="xs:integer" default="0"/>
<xs:element name="ANCHORNOMATCH" type="xs:integer" default="0"/>
<xs:element name="NOMATCHMSG" type="rb:C-1"/>
<xs:element name="TRANUUID" type="rb:C-32"/>
<xs:element name="LOGOPTION" type="xs:integer" default="1"/>
<xs:element name="MSGOPTION" type="rb:C-1"/>
<xs:element name="USERLOGFN" type="rb:C-128"/>
<xs:element name="NOITEMERROR" type="rb:C-256"/>
<xs:element name="LOGFORMAT" type="rb:C-1"/>
<xs:element name="LOGFN" type="rb:C-128"/>
<xs:element name="STEPSFN" type="rb:C-128"/>
<xs:element name="NUMNOMATCH" type="xs:integer" default="0"/>
<xs:element name="NUMERRORS" type="xs:integer" default="0"/>
<xs:element name="BUSINESSDES" type="rb:C-31"/>
<xs:element name="COMPEFFDATE" type="rb:C-31"/>
<xs:element name="ADDLRETINFONUM" type="xs:integer" default="0"/>
<xs:element name="INFO" type="rb:C-31"/>
<xs:element name="ANCHOR">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:DATABASENAME"/>
<xs:element ref="rb:DATABASEPW"/>
<xs:element ref="rb:DATABASESOURCE"/>
<xs:element ref="rb:DATABASEPRVDR"/>
<xs:element ref="rb:USERNAME"/>
<xs:element ref="rb:SEVERITYDES"/>
<xs:element ref="rb:CALLDES"/>
<xs:element ref="rb:INITACCDES"/>
<xs:element ref="rb:INITACCV"/>
<xs:element ref="rb:ITEMSEQDES"/>
<xs:element ref="rb:ITEMMATCHDES"/>
<xs:element ref="rb:CENTURYDES"/>
<xs:element ref="rb:DATEDES"/>
<xs:element ref="rb:FORMULADES"/>
<xs:element ref="rb:STRINGDES"/>
<xs:element ref="rb:VALIDATIONDES"/>
<xs:element ref="rb:STEPSDES"/>
<xs:element ref="rb:RETINFONUM"/>
<xs:element ref="rb:ADDLRETINFONUM"/>
<xs:element ref="rb:ANCHORNOMATCH"/>
<xs:element ref="rb:NOMATCHMSG"/>
<xs:element ref="rb:TRANUUID"/>
<xs:element ref="rb:LOGOPTION"/>
<xs:element ref="rb:MSGOPTION"/>
<xs:element ref="rb:USERLOGFN"/>
<xs:element ref="rb:NOITEMERROR"/>
<xs:element ref="rb:LOGFORMAT"/>
<xs:element ref="rb:LOGFN"/>
<xs:element ref="rb:STEPSFN"/>
<xs:element ref="rb:NUMNOMATCH"/>
<xs:element ref="rb:NUMERRORS"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="COVERAGE">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:COVFORMULAINDEX"/>
<xs:element ref="rb:COVINPUTS"/>
<xs:element ref="rb:COVOUTPUTS"/>
<xs:element ref="rb:COVCONTROL"/>
<xs:element ref="rb:COVEXT" minOccurs="0"/>
</xs:sequence>
<xs:attributeGroup ref="rb:ControlAttributes"/>
<xs:attribute name="RBID" type="xs:string"/>
</xs:complexType>
</xs:element>
<xs:element name="COVERAGES">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:COVERAGE" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="COVEXT">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="COVFORMULAINDEX">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="FORMREF" type="xs:string"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="COVINPUTS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="COVOUTPUTS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="EXTENDEDLOGERROR">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:LOGSOURCE"/>
<xs:element ref="rb:LOGMESSAGE"/>
<xs:element ref="rb:LOGCOVERAGE"/>
<xs:element ref="rb:LOGFORMULANAME"/>
<xs:element ref="rb:LOGRETRIEVALBUSEFFDATE"/>
<xs:element ref="rb:LOGRETRIEVALCOMPEFFDATE"/>
<xs:element ref="rb:LOGACTUALBUSEFFDT"/>
<xs:element ref="rb:LOGACTUALCOMPEFFDATE"/>
<xs:element ref="rb:LOGFORMULALINE"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="EXTENDEDNOMATCH">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:NOMATCHFORMULANAME"/>
<xs:element ref="rb:NOMATCHRETRIEVALBUSEFFDATE"/>
<xs:element ref="rb:NOMATCHRETRIEVALCOMPEFFDATE"/>
<xs:element ref="rb:NOMATCHACTUALBUSEFFDATE"/>
<xs:element ref="rb:NOMATCHACTUALCOMPEFFDATE"/>
<xs:element ref="rb:NOMATCHFORMULALINE"/>
<xs:element ref="rb:NOMATCHRATETABLEKEY"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="FORMULA">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FORMULANAME"/>
<xs:element ref="rb:FORMULARETRIEVALDATE" minOccurs="0"/>
<xs:element ref="rb:FORMULACOMPEFFDATE" minOccurs="0"/>
<xs:element ref="rb:FORMULANEWRENDES" minOccurs="0"/>
<xs:element ref="rb:FORMULAUSERATEDATE" minOccurs="0"/>
<xs:element ref="rb:FORMULARATERETRIEVALDATE" minOccurs="0"/>
<xs:element ref="rb:FORMULARATECOMPEFFDATE" minOccurs="0"/>
</xs:sequence>
<xs:attribute name="ACTIVE" type="xs:string"/>
<xs:attribute name="CURRENTIDX" type="xs:string"/>
<xs:attribute name="RBID" type="xs:string"/>
</xs:complexType>
</xs:element>
<xs:element name="FORMULACOMPEFFDATE" type="rb:C-31"/>
<xs:element name="FORMULANAME" type="rb:C-31"/>
<xs:element name="FORMULANEWRENDES" type="rb:C-31"/>
<xs:element name="FORMULARATECOMPEFFDATE" type="rb:C-31"/>
<xs:element name="FORMULARATERETRIEVALDATE" type="rb:C-31"/>
<xs:element name="FORMULARETRIEVALDATE" type="rb:C-31"/>
<xs:element name="FORMULAUSERATEDATE" type="rb:C-31"/>
<xs:element name="FORMULAS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FORMULA" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ITEM">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:ITEMINPUTS"/>
<xs:element ref="rb:ITEMOUTPUTS"/>
<xs:element ref="rb:ITEMNOMATCHES"/>
<xs:element ref="rb:ITEMCOVINDEXES"/>
<xs:element ref="rb:ITEMCONTROL"/>
<xs:element ref="rb:ITEMEXT" minOccurs="0"/>
</xs:sequence>
<xs:attributeGroup ref="rb:ControlAttributes"/>
</xs:complexType>
</xs:element>
<xs:element name="ITEMCOVINDEX">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="ACTIVE" type="xs:string"/>
<xs:attribute name="ORIGIDX" type="xs:string"/>
<xs:attribute name="COVREF" type="xs:string"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="ITEMCOVINDEXES">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:ITEMCOVINDEX" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ITEMEXT">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ITEMINPUTS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ITEMNOMATCHES">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:ITEMNUMNOMATCH" minOccurs="0"/>
<xs:element ref="rb:ITEMRETURNNOMATCH" minOccurs="0"/>
<xs:element ref="rb:NOMATCH" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ITEMNUMNOMATCH" type="xs:integer" default="0"/>
<xs:element name="ITEMOUTPUTS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ITEMRETURNNOMATCH" type="xs:integer" default="0"/>
<xs:element name="ITEMS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:ITEM" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="LEGALENTITYNAME" type="rb:C-31"/>
<xs:element name="LEGALENTITYOWNER" type="rb:C-31"/>
<xs:element name="LEGALENTITYPRODGROUP" type="rb:C-31"/>
<xs:element name="LEGALENTITYREGION" type="rb:C-31"/>
<xs:element name="LOB">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:LEGALENTITYPRODGROUP"/>
<xs:element ref="rb:LOBINPUTS"/>
<xs:element ref="rb:LOBOUTPUTS"/>
<xs:element ref="rb:REGIONS"/>
<xs:element ref="rb:LOBEXT" minOccurs="0"/>
</xs:sequence>
<xs:attributeGroup ref="rb:StatusAttributes"/>
<xs:attribute name="RQID" type="xs:string"/>
</xs:complexType>
</xs:element>
<xs:element name="LOBEXT">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="LOBINPUTS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="LOBOUTPUTS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="LOBS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:LOB" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="LOGACTUALBUSEFFDT" type="xs:string"/>
<xs:element name="LOGACTUALCOMPEFFDATE" type="xs:string"/>
<xs:element name="LOGCOVERAGE">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="COVREF" type="xs:string"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="LOGERROR">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:LOGERRORCODE"/>
<xs:element ref="rb:LOGSEVERITY"/>
<xs:element ref="rb:LOGRABSOURCE"/>
<xs:element ref="rb:LOGFORMATTEDMSG" minOccurs="0"/>
<xs:element ref="rb:EXTENDEDLOGERROR" minOccurs="0"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="LOGERRORCODE" type="xs:string"/>
<xs:element name="LOGFORMATTEDMSG" type="xs:string"/>
<xs:element name="LOGFORMULALINE" type="xs:string"/>
<xs:element name="LOGFORMULANAME" type="xs:string"/>
<xs:element name="LOGMESSAGE" type="xs:string"/>
<xs:element name="LOGRABSOURCE" type="xs:string"/>
<xs:element name="LOGRETRIEVALBUSEFFDATE" type="xs:string"/>
<xs:element name="LOGRETRIEVALCOMPEFFDATE" type="xs:string"/>
<xs:element name="LOGSEVERITY" type="xs:string"/>
<xs:element name="LOGSOURCE" type="xs:string"/>
<xs:element name="NOMATCH">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:NOMATCHCODE"/>
<xs:element ref="rb:NOMATCHTABLENAME"/>
<xs:element ref="rb:NOMATCHCOVERAGE"/>
<xs:element ref="rb:NOMATCHFORMATTEDMSG" minOccurs="0"/>
<xs:element ref="rb:EXTENDEDNOMATCH" minOccurs="0"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="NOMATCHACTUALBUSEFFDATE" type="xs:string"/>
<xs:element name="NOMATCHACTUALCOMPEFFDATE" type="xs:string"/>
<xs:element name="NOMATCHCODE" type="xs:string"/>
<xs:element name="NOMATCHCOVERAGE">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="COVREF" type="xs:string"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="NOMATCHFORMATTEDMSG" type="xs:string"/>
<xs:element name="NOMATCHFORMULALINE" type="xs:string"/>
<xs:element name="NOMATCHFORMULANAME" type="xs:string"/>
<xs:element name="NOMATCHRATETABLEKEY" type="xs:string"/>
<xs:element name="NOMATCHRETRIEVALBUSEFFDATE" type="xs:string"/>
<xs:element name="NOMATCHRETRIEVALCOMPEFFDATE" type="xs:string"/>
<xs:element name="NOMATCHTABLENAME" type="xs:string"/>
<xs:element name="NUMLOGENTRIES" type="xs:integer"/>
<xs:element name="NUMRETURNLOGENTRIES" type="xs:integer" default="0"/>
<xs:element name="RATEREQUESTEXT">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="POLEXT">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="POLICIES">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:POLICY" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="POLICY">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:BUSINESSDES"/>
<xs:element ref="rb:LEGALENTITYOWNER"/>
<xs:element ref="rb:LEGALENTITYNAME"/>
<xs:element ref="rb:COMPEFFDATE"/>
<xs:element ref="rb:RETRIEVALDATE"/>
<xs:element ref="rb:POLINPUTS"/>
<xs:element ref="rb:POLOUTPUTS"/>
<xs:element ref="rb:LOBS"/>
<xs:element ref="rb:RETINFOS"/>
<xs:element ref="rb:POLEXT" minOccurs="0"/>
</xs:sequence>
<xs:attributeGroup ref="rb:StatusAttributes"/>
<xs:attribute name="RQID" type="xs:string"/>
</xs:complexType>
<xs:key name="FORMKEY">
<xs:selector xpath="rb:LOBS/rb:LOB/rb:REGIONS/rb:REGION/rb:FORMULAS/rb:FORMULA"/>
<xs:field xpath="@RBID"/>
</xs:key>
<xs:keyref name="FORMREF" refer="rb:FORMKEY">
<xs:selector xpath="rb:LOBS/rb:LOB/rb:REGIONS/rb:REGION/rb:COVERAGES/rb:COVERAGE/rb:COVFORMULAINDEX"/>
<xs:field xpath="@FORMREF"/>
</xs:keyref>
</xs:element>
<xs:element name="POLINPUTS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="POLOUTPUTS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="RATABASECALC">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:RATEREQUEST" maxOccurs="unbounded"/>
</xs:sequence>
<xs:attribute name="COPYRIGHT" type="xs:string" fixed="COPYRIGHT 2001, CGI INFORMATION SYSTEMS AND MANAGEMENT CONSULTANTS, INC., PROPRIETARY AND CONFIDENTIAL"/>
<xs:attribute name="VERSION" type="xs:string" use="required"/>
<xs:attribute name="DTDCREATEDATE" type="xs:string" use="required"/>
<xs:attribute name="DTDCREATETIME" type="xs:string" use="required"/>
<xs:attribute name="RBXMLCREATEDATE" type="xs:string"/>
<xs:attribute name="RBXMLCREATETIME" type="xs:string"/>
<xs:attribute name="RBXMLTYPE" type="rb:RBXMLType"/>
<xs:attribute name="XMLCREATEDATE" type="xs:string"/>
<xs:attribute name="XMLCREATETIME" type="xs:string"/>
<xs:attribute name="XMLTYPE" type="rb:RBXMLType"/>
<xs:attribute name="DUMPRB" type="rb:IndicatorType"/>
<xs:attribute name="DUMPRBFILE" type="xs:string"/>
<xs:attribute name="RATEREQUESTEXT" type="xs:string"/>
</xs:complexType>
</xs:element>
<xs:element name="RATEREQUEST">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:ANCHOR"/>
<xs:element ref="rb:POLICIES"/>
<xs:element ref="rb:RATEREQUESTEXT" minOccurs="0"/>
</xs:sequence>
<xs:attributeGroup ref="rb:StatusAttributes"/>
<xs:attribute name="OPTRATINGIND" type="rb:IndicatorType"/>
<xs:attribute name="REPLACEMENTCHAR">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="_"/>
<xs:enumeration value="."/>
<xs:enumeration value="-"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="USEREFID" type="rb:IndicatorType"/>
<xs:attribute name="RQID" type="xs:string"/>
</xs:complexType>
</xs:element>
<xs:element name="REGION">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:LEGALENTITYREGION"/>
<xs:element ref="rb:REGIONINPUTS"/>
<xs:element ref="rb:REGIONOUTPUTS"/>
<xs:element ref="rb:REGIONERRORS"/>
<xs:element ref="rb:COVERAGES"/>
<xs:element ref="rb:ITEMS"/>
<xs:element ref="rb:FORMULAS"/>
<xs:element ref="rb:REGIONCONTROL"/>
<xs:element ref="rb:REGIONEXT" minOccurs="0"/>
</xs:sequence>
<xs:attributeGroup ref="rb:StatusAttributes"/>
</xs:complexType>
<xs:key name="COVKEY">
<xs:selector xpath="rb:COVERAGES/rb:COVERAGE"/>
<xs:field xpath="@RBID"/>
</xs:key>
<xs:keyref name="COVREF" refer="rb:COVKEY">
<xs:selector xpath="rb:ITEMS/rb:ITEM/rb:ITEMCOVINDEXES/rb:ITEMCOVINDEX"/>
<xs:field xpath="@COVREF"/>
</xs:keyref>
<xs:keyref name="LOGCOVREF" refer="rb:COVKEY">
<xs:selector xpath="rb:REGIONERRORS/rb:LOGERROR/rb:EXTENDEDLOGERROR/rb:LOGCOVERAGE"/>
<xs:field xpath="@COVREF"/>
</xs:keyref>
<xs:keyref name="NOMATCHCOVREF" refer="rb:COVKEY">
<xs:selector xpath="rb:ITEMS/rb:ITEM/rb:ITEMNOMATCHES/rb:NOMATCH/rb:NOMATCHCOVERAGE"/>
<xs:field xpath="@COVREF"/>
</xs:keyref>
</xs:element>
<xs:element name="REGIONERRORS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:NUMLOGENTRIES" minOccurs="0"/>
<xs:element ref="rb:NUMRETURNLOGENTRIES" minOccurs="0"/>
<xs:element ref="rb:LOGERROR" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="REGIONEXT">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="REGIONINPUTS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="REGIONOUTPUTS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:FLD" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="REGIONS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:REGION" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="RETINFO">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:RETURNINFOFORMULANAME" minOccurs="0"/>
<xs:element ref="rb:RETURNINFORATETABLENAME" minOccurs="0"/>
<xs:element ref="rb:RETURNINFONAME" minOccurs="0"/>
<xs:element ref="rb:RETURNINFOVALUE" minOccurs="0"/>
<xs:element ref="rb:RETURNINFOROW" minOccurs="0"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="RETINFOS">
<xs:complexType>
<xs:sequence>
<xs:element ref="rb:TOTALRI"/>
<xs:element ref="rb:RETINFO" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="RETRIEVALDATE" type="xs:string"/>
<xs:element name="RETURNINFOFORMULANAME" type="xs:string"/>
<xs:element name="RETURNINFONAME" type="xs:string"/>
<xs:element name="RETURNINFORATETABLENAME" type="xs:string"/>
<xs:element name="RETURNINFOROW" type="xs:string"/>
<xs:element name="RETURNINFOVALUE" type="xs:string"/>
<xs:element name="TOTALRI" type="xs:string"/>
<xs:complexType name="REGIONCONTROLType"/>
<xs:complexType name="COVCONTROLType"/>
<xs:complexType name="ITEMCONTROLType"/>
<xs:element name="REGIONCONTROL" type="rb:REGIONCONTROLType"/>
<xs:element name="COVCONTROL" type="rb:COVCONTROLType"/>
<xs:element name="ITEMCONTROL" type="rb:ITEMCONTROLType"/>
</xs:schema>

--------------------------------------------------------

and i am trying to generate data from table to show following xml way. Please cut and paste this too and take a look.

If any one can tell or have any procedure to do that .
xml file,
<?xml version="1.0" encoding="UTF-8"?>
<!--Sample XML file generated by XMLSpy v2007 rel. 3 sp1 (http://www.altova.com)-->
<RATABASECALC XMLCREATEDATE="String" XMLCREATETIME="String" COPYRIGHT="String" DTDCREATEDATE="String" DTDCREATETIME="String" VERSION="String" XMLTYPE="String" xsi:noNamespaceSchemaLocation="cGIinrb1za.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RATEREQUEST USEREFID="String">
<ANCHOR>
<DATABASENAME>text</DATABASENAME>
<DATABASEPW>text</DATABASEPW>
<DATABASESOURCE>text</DATABASESOURCE>
<DATABASEPRVDR>text</DATABASEPRVDR>
<USERNAME>text</USERNAME>
<SEVERITYDES>text</SEVERITYDES>
<CALLDES>text</CALLDES>
<INITACCDES>text</INITACCDES>
<INITACCV>text</INITACCV>
<ITEMSEQDES>text</ITEMSEQDES>
<ITEMMATCHDES>text</ITEMMATCHDES>
<CENTURYDES>text</CENTURYDES>
<DATEDES>text</DATEDES>
<FORMULADES>text</FORMULADES>
<STRINGDES>text</STRINGDES>
<VALIDATIONDES>text</VALIDATIONDES>
<STEPSDES>text</STEPSDES>
<RETINFONUM>text</RETINFONUM>
<ADDLRETINFONUM>text</ADDLRETINFONUM>
<ANCHORNOMATCH>text</ANCHORNOMATCH>
<NOMATCHMSG>text</NOMATCHMSG>
<TRANUUID>text</TRANUUID>
<LOGOPTION>text</LOGOPTION>
<MSGOPTION>text</MSGOPTION>
<USERLOGFN>text</USERLOGFN>
<NOITEMERROR>text</NOITEMERROR>
<LOGFORMAT>text</LOGFORMAT>
<LOGFN>text</LOGFN>
<STEPSFN>text</STEPSFN>
<NUMNOMATCH>255</NUMNOMATCH>
<NUMERRORS>255</NUMERRORS>
</ANCHOR>
<POLICIES>
<POLICY>
<BUSINESSDES>String</BUSINESSDES>
<LEGALENTITYOWNER>String</LEGALENTITYOWNER>
<LEGALENTITYNAME>String</LEGALENTITYNAME>
<COMPEFFDATE>String</COMPEFFDATE>
<RETRIEVALDATE>String</RETRIEVALDATE>
<POLINPUTS>
<FLD NM="POLICY NUMBER"> 1422395 </FLD>
<FLD NM="POLICY TERM TYPE">'DR' </FLD>
<FLD NM="POLICY TERM LENGHT">1 </FLD>
<FLD NM="POLICY EFFECTIVE DATE"> 08/04/2007 </FLD>
<FLD NM="POLICY EXPIRY DATE"> 08/24/2007</FLD>
</POLINPUTS>
<LOBS>
<LOB>
<LEGALENTITYPRODGROUP>String</LEGALENTITYPRODGROUP>
<LOBINPUTS>
</LOBINPUTS>
<LOBOUTPUTS>text</LOBOUTPUTS>
<REGIONS>
<REGION>
<LEGALENTITYREGION>String</LEGALENTITYREGION>
<REGIONINPUTS>
</REGIONINPUTS>
<REGIONOUTPUTS>
</REGIONOUTPUTS>
<REGIONERRORS>
<NUMLOGENTRIES>255</NUMLOGENTRIES>
<NUMRETURNLOGENTRIES>text</NUMRETURNLOGENTRIES>
</REGIONERRORS>
<COVERAGES>
<COVERAGE RBID="String">
<COVFORMULAINDEX FORMREF="String"/>
<COVINPUTS>
<FLD NM="Audio Limit">1000</FLD>
<FLD NM="ERS Limit">2000</FLD>
<FLD NM="TPL Limit">3000</FLD>
<FLD NM="CONTRACT ID">1422395</FLD>
<FLD NM="YEARS OF EXPERIENCED">5</FLD>
</COVINPUTS>
<COVOUTPUTS>
</COVOUTPUTS>
<COVCONTROL>text</COVCONTROL>
</COVERAGE>
</COVERAGES>
<ITEMS>
<ITEM>
<ITEMINPUTS>
<FLD NM="PARTITION NO">1</FLD>
<FLD NM="YEARS OF EXPERIENCED">5</FLD>
<FLD NM="MODEL YEAR">1997</FLD>
<FLD NM="TERRITORY">001</FLD>
</ITEMINPUTS>
<ITEMOUTPUTS>
</ITEMOUTPUTS>
<ITEMNOMATCHES>
<ITEMNUMNOMATCH>255</ITEMNUMNOMATCH>
<ITEMRETURNNOMATCH>text</ITEMRETURNNOMATCH>
</ITEMNOMATCHES>
<ITEMCOVINDEXES>
<ITEMCOVINDEX COVREF="String"/>
</ITEMCOVINDEXES>
<ITEMCONTROL>text</ITEMCONTROL>
</ITEM>
</ITEMS>
<FORMULAS>
<FORMULA RBID="String">
<FORMULANAME>String</FORMULANAME>
<FORMULARETRIEVALDATE>String</FORMULARETRIEVALDATE>
<FORMULACOMPEFFDATE>String</FORMULACOMPEFFDATE>
<FORMULANEWRENDES>String</FORMULANEWRENDES>
<FORMULAUSERATEDATE>String</FORMULAUSERATEDATE>
<FORMULARATERETRIEVALDATE>String</FORMULARATERETRIEVALDATE>
<FORMULARATECOMPEFFDATE>String</FORMULARATECOMPEFFDATE>
</FORMULA>
</FORMULAS>
<REGIONCONTROL>text</REGIONCONTROL>
</REGION>
</REGIONS>
</LOB>
</LOBS>
<RETINFOS>
<TOTALRI>text</TOTALRI>
</RETINFOS>
</POLICY>
</POLICIES>
</RATEREQUEST>
</RATABASECALC>
--------------------------------------------------------------

can any one print result in
<...> --tag in herarcy
<...> -- tag in herarcy
<policies>
<policy>
<ITEMS>
<ITEMS>
<FLD NM = "AUDIO LIMIT">100 </FLD>
<FLD NM = "TPL LIMIT">100 </FLD>
</ITEM>
</ITEMS>
<...>
<..>
</POLICY>
</POLICIES>






  • Attachment: RBGENERIC.xsd
    (Size: 23.14KB, Downloaded 243 times)
Previous Topic: XML Data Extarct in oracle 9i
Next Topic: Executable(EXE) of Java/JSP
Goto Forum:
  


Current Time: Thu Dec 08 10:27:23 CST 2016

Total time taken to generate the page: 0.24576 seconds