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.
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, 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