OraFAQ Forum: JDeveloper, Java & XML » Query Reg XSLT conversion in Oracle9i

Home » Developer & Programmer » JDeveloper, Java & XML » Query Reg XSLT conversion in Oracle9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query Reg XSLT conversion in Oracle9i [message #145715]

Sat, 05 November 2005 04:47

pritambiswas
Messages: 1
Registered: November 2005

Junior Member

Hi ,

I need to covert the following XML into another form of XML using XSLT in Oracle 9i . The discrepancy between the two xmls are highlighted in Bold. Please provide any pointers how to do it.

Request XML

<cr:request xmlns:cr="http://www.bt.com/btgs/solutions/message/customerRequest"
xmlns:prodType="http://www.bt.com/btgs/solutions/library/ProductType">
<sourceSystem NAME="Expedio RM" TYPE="Remedy"/>
<targetSystem NAME="DECOMP" TYPE=".NET"/>
<changeRequest>
<contactInfo organizationName="INFY">
<firstName>Steve</firstName>
<lastName>Boswel</lastName>
</contactInfo>
<billofMaterial>
<bomsiteItem>
<SiteName>HSBC Canary Wharf</SiteName>
<siteItem>
<SERV_ID>SER_01</SERV_ID>
<ORDERITEMACTION>0</ORDERITEMACTION>
<prodTypenetworkProduct xmls:prodType”http://asdf.com” instance_id="ID000020"> <CONN_ID>CONN_01</CONN_ID>
<SERV_ID>SER_01</SERV_ID>
<PRODUCTNAME>0</PRODUCTNAME>
<PRODUCTDESCRIPTION>0</PRODUCTDESCRIPTION>
<SERVICEIDENTIFIER>0</SERVICEIDENTIFIER>
<AENDSITEID>0</AENDSITEID>
<AENDCPE>0</AENDCPE>
<ABEARERID>0</ABEARERID>
<ASSOCIATEDPACKAGEINSTANCE>0</ASSOCIATEDPACKAGEINSTANCE>
<NETWORKPRODUCTDETAILS>
<param>BANDWIDTH</param>
<value>256</value>
<param>SERVICE CATEGORY</param>
<value>GOLD</value>
<param>DATACENTRE1</param>
<value>Docklands</value>
<param>ROUTING TOPOLOGY</param>
<value>Spoke</value>
</NETWORKPRODUCTDETAILS>
</prodTypenetworkProduct>
</siteItem>
<siteItem>
<SERV_ID>SER_02</SERV_ID>
<ORDERITEMACTION>0</ORDERITEMACTION>
<prodTypenetworkProduct xmls:prodType” http://asdf.com” instance_id="ID000020"> <CONN_ID>CONN_02</CONN_ID>
<SERV_ID>SER_02</SERV_ID>
<PRODUCTNAME>0</PRODUCTNAME>
<PRODUCTDESCRIPTION>0</PRODUCTDESCRIPTION>
<SERVICEIDENTIFIER>0</SERVICEIDENTIFIER>
<AENDSITEID>0</AENDSITEID>
<AENDCPE>0</AENDCPE>
<ABEARERID>0</ABEARERID>
<ASSOCIATEDPACKAGEINSTANCE>0</ASSOCIATEDPACKAGEINSTANCE>
<NETWORKPRODUCTDETAILS>
<param>ROUTING TOPOLOGY</param>
<value>Spoke</value>
<param>SERVICE CATEGORY</param>
<value>Silver</value>
<param>DATACENTRE1</param>
<value>Docklands</value>
<param>BANDWIDTH</param>
<value>1024</value>
</NETWORKPRODUCTDETAILS>
</prodTypenetworkProduct >
</siteItem>
</bomsiteItem>
</billofMaterial>
</changeRequest>
</cr:request>

Response XML

<cr:request xmlns:cr="http://www.bt.com/btgs/solutions/message/customerRequest"
xmlns:prodType="http://www.bt.com/btgs/solutions/library/ProductType">
<sourceSystem NAME="Expedio RM" TYPE="Remedy"/>
<targetSystem NAME="DECOMP" TYPE=".NET"/>
<changeRequest>
<contactInfo organizationName="INFY">
<firstName>Steve</firstName>
<lastName>Boswel</lastName>
</contactInfo>
<billofMaterial>
<bomsiteItem>
<SiteName>HSBC Canary Wharf</SiteName>
<siteItem>
<SERV_ID>SER_01</SERV_ID>
<ORDERITEMACTION>0</ORDERITEMACTION>
<prodType:networkProduct instance_id="ID000020">
<CONN_ID>CONN_01</CONN_ID>
<SERV_ID>SER_01</SERV_ID>
<PRODUCTNAME>0</PRODUCTNAME>
<PRODUCTDESCRIPTION>0</PRODUCTDESCRIPTION>
<SERVICEIDENTIFIER>0</SERVICEIDENTIFIER>
<AENDSITEID>0</AENDSITEID>
<AENDCPE>0</AENDCPE>
<ABEARERID>0</ABEARERID>
<ASSOCIATEDPACKAGEINSTANCE>0</ASSOCIATEDPACKAGEINSTANCE>
<NETWORKPRODUCTDETAILS>
<param>BANDWIDTH</param>
<value>256</value>
<param>SERVICE CATEGORY</param>
<value>GOLD</value>
<param>DATACENTRE1</param>
<value>Docklands</value>
<param>ROUTING TOPOLOGY</param>
<value>Spoke</value>
</NETWORKPRODUCTDETAILS>
</prodType:networkProduct>
</siteItem>
<siteItem>
<SERV_ID>SER_02</SERV_ID>
<ORDERITEMACTION>0</ORDERITEMACTION>
<prodType:networkProduct instance_id="ID000020"> <CONN_ID>CONN_02</CONN_ID>
<SERV_ID>SER_02</SERV_ID>
<PRODUCTNAME>0</PRODUCTNAME>
<PRODUCTDESCRIPTION>0</PRODUCTDESCRIPTION>
<SERVICEIDENTIFIER>0</SERVICEIDENTIFIER>
<AENDSITEID>0</AENDSITEID>
<AENDCPE>0</AENDCPE>
<ABEARERID>0</ABEARERID>
<ASSOCIATEDPACKAGEINSTANCE>0</ASSOCIATEDPACKAGEINSTANCE>
<NETWORKPRODUCTDETAILS>
<param>ROUTING TOPOLOGY</param>
<value>Spoke</value>
<param>SERVICE CATEGORY</param>
<value>Silver</value>
<param>DATACENTRE1</param>
<value>Docklands</value>
<param>BANDWIDTH</param>
<value>1024</value>
</NETWORKPRODUCTDETAILS>
</prodType:networkProduct>
</siteItem>
</bomsiteItem>
</billofMaterial>
</changeRequest>
</cr:request>

Note : The prodType namespace has been removed in the response XML and the tag name is changed from < prodTypenetworkProduct > to
< prodType:networkProduct>

Report message to a moderator