Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODP.NET - C# How to retrieve XML from stored procedure in .NET?

519887Jun 23 2006 — edited Dec 1 2006
Hi friends,

In SQL Server 2000, we have FOR XML [Auto | Raw | Explicit] clause and we can get XML from stored procedure using SQLCommand's ExecuteXMLReader method.

What's the equivalent for C# - Oracle10g scenario? Can you pls.send me a simple stored procedure & C# source code to get XML from stored proc.?

(ODP.NET's OracleCommand does have ExecuteXmlReader method, but I didn't find a single example where a stored procedure is used...)

Thanks,
Amit
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2006
Added on Jun 23 2006
3 comments
13,936 views