5(j). Map Sequence Rule - <map-seq> (only for Oracle)
Connect XML-2-DB supports the use of sequences for Oracle databases. The next
value of a specified sequence can be inserted into a database column.
The next value of a sequence can also be passed in as a parameter to a
procedure. This is done using the map-seq and the
sequence-reference-information rule. The format of map-seq rule
is as follows
<!ELEMENT map-seq EMPTY>
<!ATTLIST map-seq
element-name CDATA #REQUIRED
seq-reference CDATA #REQUIRED
table-reference CDATA #IMPLIED
proc-reference CDATA #IMPLIED
column-name CDATA #IMPLIED
param-name CDATA #IMPLIED>
Suppose that a sequence SALES_ID_SEQ exists
in the database and this sequence has to be used to generate a value for
the SALE_ID column of the SALES table. The mapping file should have the
following rules defined:
<table-reference-information table-reference="Sales" table-name="SALES"/>
<sequence-reference-information seq-reference="SalesIdSeq" seq-name="SALES_ID_SEQ"/>
<map-seq
element-name="software-sale"
seq-reference="SalesIdSeq"
table-reference="Sales"
column-name="SALES_ID"/>
|