|
[XML-DEV Mailing List Archive Home]
[By Thread]
[By Date]
[Recent Entries]
[Reply To This Message]
Oracle SQL - XML Builder [ was : Is this Impossible !!]
- From: "Abhishek Srivastava" <abisheks@i...>
- To: "xml dev mailing list" <xml-dev@i...>
- Date: Fri, 22 Oct 1999 11:22:11 +0530
 |
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format
| RSS 2.0 |
 |
| Atom 0.3 |
 |
| |
Stylus Studio has published XML-DEV in RSS and ATOM formats,
enabling users to easily subcribe to the list from their preferred news reader application.
|
Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website.
they were not included by the author in the initial post. To view the content without the Sponsor Links please
click here.
|
|
Cart
