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
I'm not sure what the current prefered method is but you might want to try the XDK: http://otn.oracle.com/tech/xml/xdk_java/content.html This works with 8i also. I have to say that the performance is totally hopeless, so you may want to think about writing your own resultset->xml converter. I'm sure people will have other suggestions....
