aspose file tools*
The moose likes XML and Related Technologies and the fly likes How to get data in xml format from oracle 9i thru stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "How to get data in xml format from oracle 9i thru stored procedure" Watch "How to get data in xml format from oracle 9i thru stored procedure" New topic
Author

How to get data in xml format from oracle 9i thru stored procedure

Anil Jain
Ranch Hand

Joined: Mar 10, 2002
Posts: 51
Friends:
Is there any way whereby I can get the data in xml format from an oracle database (9i) thru stored procedure.
To rephrase: i have to write stored procedure in oracle 9i which will return data in xml format.
Regards


Anil Jain<br />Sun Certified Java(2) Programmer
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Anil,
Have a look on the Oracle technet website where you can find the XML SQL Utility for Java. This utility helps generating XML Documents from SQL queries.
You may also code your stored procedure in Java to access the Java classes that come with the Oracle XDK.
Cheers
 
 
subject: How to get data in xml format from oracle 9i thru stored procedure