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


Help: OASIS Mailing Lists Help | MarkMail Help



   RE: [xml-dev] Oracle and XML

[ Lists Home | Date Index | Thread Index ]

Hi Thi,

>Has any one knew how to get XML from an Oracle database table? 

You can try (a) XSU (XML SQL Utility) [1] for Java getXML, or (b) XSQL [2].

If you already got SQL statements ready for porting, option a is pretty straightforward, as all you need is put it into a java command something like

java OracleXML getXML -user <username/password> -conn <connection string> <SQL statement>

The output is purely XML well-formed, can be redirected to a file if preferred.

If you only wanted to pick up data from small number of table fields, then option b can be considered.

For jdk1.2.x, xsu12.jar and JDBC2.x are the environment you need to set up; otherwise xsu11.jar and JDBC1.x are for jdk1.1.x.

Hope this helps.

Spenser Kao

[1] http://www.stanford.edu/dept/itss/docs/oracle/9i/appdev.920/a96621/adx08xsu.htm

[2] http://www.stanford.edu/dept/itss/docs/oracle/9i/appdev.920/a96621/adx09xsq.htm#1029237




----------------------------------------------------------------- The xml-dev list is sponsored by XML.org , an initiative of OASIS The list archives are at http://lists.xml.org/archives/xml-dev/ To subscribe or unsubscribe from this list use the subscription manager:

  • References:


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

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