This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
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


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
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