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

[Abhishek Srivastava]

Hi ,

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 ?

Thanks,
Abhishek.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    _/               Abhishek Srivastava
   _/                Hewlett Packard ISO       
  _/_/_/   _/_/_/    -------------------   
 _/   /   _/  _/     (Work)   +91-80-2251554 x1190
_/  _/   _/_/_/      (Ip)     15.10.47.37            
        _/           (Url)    http://sites.netscape.net/abhishes/homepage                        
       _/            You've heard it all by now. Get wired or get whacked. 
                     You're networking or you're not working. Dot-com or die 
                     - SUN MICROSYSTEMS 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ic.ac.uk/pipermail/xml-dev/attachments/19991022/87596082/attachment.htm