OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

 


 

   Re: Oracle SQL - XML Builder [ was : Is this Impossible !!]

[ Lists Home | Date Index | Thread Index ]
  • From: "Thomas B. Passin" <tpassin@idsonline.com>
  • To: "xml dev mailing list" <xml-dev@ic.ac.uk>
  • Date: Fri, 22 Oct 1999 08:05:08 -0400

Here's two ways:
 
1) Transform the Oracle output using and xslt stylesheet and one of the xslt processors like XT.
2) Write a script for a text- processing program like awk, perl, or python to change the tag names to the ones you want and delete the ones you don't.  This approach would be fast and easy.
 
Thomas Passin
 
 
I tried the Oracle's SQL - XML utility and it does what i want.  Except a few things.
 
I generated the following XML file as a result to a query to my oracle database.
 
<ROWSET>
 <ROW num="1">
  <SPNAME>Huntington services Company             </SPNAME>
  <CUSTPERMID>123456789123456     </CUSTPERMID>
  <CUSTLOGINID>jamesb              </CUSTLOGINID>
  <FIRSTNAME>james </FIRSTNAME>
  <LASTNAME>Bond </LASTNAME>
 </ROW>
 </ROW>
</ROWSET>
 
The ROWSET and the ROW tags were introduced by the builder itself. I would like the document to look like :
 
<CUSTID>
<SPNAME>My Own Business  Services Company  </SPNAME>
  <CUSTPERMID>123456789123456     </CUSTPERMID>
  <CUSTLOGINID>jamesb              </CUSTLOGINID>
  <FIRSTNAME>james               </FIRSTNAME>
  <LASTNAME>Bond                </LASTNAME>
 </CUSTID>
This is very important because this xml file will be sent to the client who will "validate" it. Since ROWSET and ROW are not a part of standard message format we use... an exception will be thrown.
Is there any way to customize the output from the builder so that it conforms to a predefined DTD ?
 
 




 

News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS