<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>Here's two ways:</DIV>
<DIV> </DIV>
<DIV>1) Transform the Oracle output using and xslt stylesheet and one of the
xslt processors like XT.</DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Thomas Passin</DIV>
<DIV> </DIV>
<DIV><B>From:</B> <A href="mailto:abisheks@india.hp.com"
title=abisheks@india.hp.com>Abhishek Srivastava</A> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I tried the Oracle's SQL - XML utility and it
does what i want. Except a few things.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I generated the following XML file as a result to
a query to my oracle database.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><ROWSET><BR> <ROW
num="1"><BR> <SPNAME>Huntington services
Company
</SPNAME><BR>
<CUSTPERMID>123456789123456
</CUSTPERMID><BR>
<CUSTLOGINID>jamesb
</CUSTLOGINID><BR>
<FIRSTNAME>james </FIRSTNAME><BR>
<LASTNAME>Bond </LASTNAME><BR> </ROW><BR> </ROW><BR></ROWSET></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The ROWSET and the ROW tags were introduced
by the builder itself. I would like the document to look like :</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><CUSTID></FONT></DIV>
<DIV><FONT face=Arial size=2><SPNAME>My Own Business Services
Company </SPNAME><BR>
<CUSTPERMID>123456789123456
</CUSTPERMID><BR>
<CUSTLOGINID>jamesb
</CUSTLOGINID><BR>
<FIRSTNAME>james
</FIRSTNAME><BR>
<LASTNAME>Bond
</LASTNAME><BR> </CUSTID><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2>Is there any way to customize the output from the
builder so that it conforms to a predefined DTD ?</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>