Q: ADO.NET Reading XMLTypes > 4000 chars

  • Thread starter Thread starter gm0ney
  • Start date Start date
G

gm0ney

I can't seem to find anything on this subject.

I find examples, but they do not work when the return value
for the column is over 4000 chars.


I know the underlying type for the XMLType is a CLOB, but
I can't seemed to find a way to get this value out of the DB
with ADO.NET using either the MS provider for the ODP.NET
provider.

Anyone got a sample or example?



Thanks,
g
 
Anyone got a sample or example?
Click to expand...

Never mind... I figured it out right after I posted this... doh!
Stupid 2 lines of code.... bah

Its basically this if anyone else needs help with this.
This is done with the ODP.NET from Oracle

--- snippet ---

Dim dr as OracleDataReader = cmd.ExecuteReader
Dim oraXMLType as OracleXmlType

While dr.Read
oraXMLType = dr.GetOracleXmlType(0)
End While

Dim oXML as Xml.XmlDocument = oraXMLType.GetXmlDocument

--- snippet ---



g
 
Back
Top