在C#中将Clob转换为Xml [英] Convert clob to Xml in c#

问题描述

如何从Clob转换为xml

How to convert from clob to xml

OCmd.Parameters.Add(":IN_REQUEST_OID", OracleDbType.Int64).Value = OID;
OCmd.Parameters.Add(":IN_CONTRACT_OID", OracleDbType.Int64).Value = ContractOID;
OCmd.Parameters.Add(":IN_CONTRACT_TYPE", OracleDbType.Varchar2).Value = ContractType;
OCmd.Parameters.Add(":OUT_INPUT_XML", OracleDbType.Clob, Input_XML, ParameterDirection.Output);
OCmd.Parameters.Add(":OUT_OUTPUT_XML", OracleDbType.Clob, Output_XML, ParameterDirection.Output);

OCmd.Connection.Open();
OCmd.ExecuteNonQuery();

DataSet ds = new DataSet();
ds.Tables.Add(new DataTable());
ds.Tables[0].Columns.Add("INPUT");
ds.Tables[0].Columns.Add("OUTPUT");
ds.Tables[0].Columns.Add("SERVER_NAME");
DataRow dr = ds.Tables[0].NewRow();
ds.Tables[0].Rows.Add(dr);

我想将以下获得的clob值转换为XML
是否可以将其转换为XML.

I want to convert following obtained clob value into XML
Is it possible to typecast it into XML.

ds.Tables[0].Rows[0]["INPUT"] =(Oracle.DataAccess.Types.OracleClob)OCmd.Parameters[3].Value).Value;
ds.Tables[0].Rows[0]["OUTPUT"] = ((Oracle.DataAccess.Types.OracleClob)OCmd.Parameters[4].Value).Value;
OCmd.Connection.Close();

[edit]添加了代码标签

[edit] Code tags added

推荐答案

尝试将Oracle CLOB强制转换为.Net String，然后将String加载到XMLDocument中. http://www.code-magazine.com/article.aspx?quickid=0311071& page = 3 [ ^ ]

Try casting the Oracle CLOB to .Net String and then load the String into XMLDocument.
http://www.code-magazine.com/article.aspx?quickid=0311071&page=3[^]

这篇关于在C#中将Clob转换为Xml的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！