CODEWITHSUNDEEP
oracle-databaseado.netxmltype
user787951
user787951

Reputation:

how to retrieve the data from xmltype parameter returned from stored proc

I have a stored proc it returns xmltype parameter. How to get the data from that using vb.net?

db.Parameters("param", Oracle.DataAccess.Client.OracleDbType.XmlType, _
                                           Data.ParameterDirection.Output)

Upvotes: 0

Views: 995

Answers (1)

Stephen ODonnell
Stephen ODonnell

Reputation: 4466

I've never used VB.net, but if you have the ability to change the stored procedure, I would consider converting the XMLTYPE to a CLOB and returning that instead (using xmltype.getclobval() ) I find it unlikely that the .net Oracle driver will provide support for XMLTYPE.

Obviously that will mean you need to make use of an XML parser in the VB code to parse the string (stored in the clob) to access any of the XML fields within it.

Upvotes: 1

Related Questions