|
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| 