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.

Report message to a moderator

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

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Many examples in the "JDeveloper, Java & XML" forum to which I move this topic.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 17 22:58:08 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.