DBAzine.com

Sections

Personal tools

You are not logged in
Log in
Join

You are here: Home » SQL Server » SQL Server Articles Archive » Calling Stored Procedures from ADO.NET » How to retrieve XML from Oracle stored procedure in C#?

Seeking new owner for this high-traffic DBAzine.com site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today.

Who Are You?

I am a:
[ Results | Polls ]
Votes : 3568

Comment

Above in this comment thread: Calling Stored Procedures from ADO.NET

How to retrieve XML from Oracle stored procedure in C#?

Posted by amitmahajan at 2006-06-23 04:13 AM

In SQL Server 2000, we have FOR XML [Auto/Raw/Explicit] clause. We can use SQLCommand's ExecuteXMLReader method to get XML from a SQL Server stored procedure.

What is the equivalent solution for Oracle? In ODP.NET, OracleCommand does have ExecuteXMLReader method. Can you please explain how to write a simple stored procedure (that returns XML) and get XML in C#?

Thanks,
Amit

Need solution for Oracle10g

Posted by amitmahajan at 2006-06-23 04:15 AM

PS. I'm using Oracle10g

Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience.
Free White Paper

Database Recovery
Feeling the increased demands on data protection and storage requirements?
Download Free Report!