Returning Xml as text from Oracle Stored Proc

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: AndrewH (AndrewH_at_discussions.microsoft.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 01:51:02 -0700

I am returning Xml from an oracle stored procedure using the Oracle managed provider, using a ref cursor to fill a dataset.
The Xml is stored as a varchar on the database, but when I retrieve it, all newline tab and double quote characters have been escaped. e.g.

"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<regstudio>\n\t

It looks fine when running the stored proc in Sql+.

Relevant Pages

  • Re: Accessing Oracle Database - Arun , Jaiganesh
    ... It is not advisable to group all the value of different data type and ... send to Oracle Stored procedure for insertion using ADO.NET. ... I'm not quite familiar with Oracle Xml. ...
    (microsoft.public.dotnet.framework.adonet)
  • Ruby sample code for PLSQL REF CURSORS
    ... I am having hard time to find a sample that shows me how to return an OUT ... REF CURSOR from my oracle stored procedure to my python program. ...
    (comp.lang.ruby)
  • Accessing Oracle Ref cursor with Ole DB provider for Oracle
    ... I'd like to know, if it is possible, how I could access a ref cursor, ... returned by an Oracle stored procedure, in my VB.net application using the ... so I don't know wich type I can use for my OUTPUT parameter ... Cedric FABIOUX ...
    (microsoft.public.dotnet.framework)
  • How to get multi ref cursors returned by an Oracle stored procedure?
    ... I have an Oracle stored procedure like the following: ... ref cursor out c2) as ... How can I get these 2 returned cursors and cast them to datasets in Delphi ... Thanks for any clues. ...
    (borland.public.delphi.database.ado)
  • DAAB with Oracle ref cursors
    ... Can anybody send me an example of calling an Oracle stored procedure which returns a ref cursor using Enterprise Library DAAB? ...
    (microsoft.public.dotnet.framework.adonet)