Home » Developer & Programmer » JDeveloper, Java & XML » Returning XML recordset from Oracle (10G)
Returning XML recordset from Oracle [message #361602] Thu, 27 November 2008 03:04 Go to next message
rawat_me
Messages: 45
Registered: September 2005
Member
Hi All,
Just wondering is there any good way to Return XML recordset from Oracle to .Net application.

I know how to generate XML file from Oracle.

Will it be good idea to insert the XML created data in a table as CLOB data and then retrun those records as recordset to my .Net application.

Any Suggestions would be appriciated.
Re: Returning XML recordset from Oracle [message #361609 is a reply to message #361602] Thu, 27 November 2008 03:18 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Read the documentation about using XMLTYPE

Link
Re: Returning XML recordset from Oracle [message #361612 is a reply to message #361602] Thu, 27 November 2008 03:22 Go to previous message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Many examples in the "JDeveloper, Java & XML" forum to which I move this topic.

Regards
Michel
Previous Topic: synonym/grant for constraint tables
Next Topic: xml parsing in pl/sql
Goto Forum:
  


Current Time: Fri Dec 26 04:53:36 CST 2014

Total time taken to generate the page: 0.07794 seconds