ODP.NET - C# How to retrieve XML from stored procedure in .NET?
519887Jun 23 2006 — edited Dec 1 2006Hi 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