需要读取oracle视图sql语句,用PL/ Sql读取出来显示是Long类型,点击可以查看到sql,但是用C#程序怎么读取到呢?用OracleDataAdapter加载到DataTable显示是空字符串,用DataReader也显示是字符串类型且也是空字符串,明明查询结果应该是有数据的啊,服了Oracle,简单的结果读取都这么麻烦,望高手指教一下哦,以下附源码:
OracleConnection conn = new OracleConnection(connString);
string sql1 = string.Format("select text from user_views");//PL Sql中能查到数据,是大文本
//1.用OracleDataAdapter的方式
OracleDataAdapter vAdapter = new OracleDataAdapter(sql1, conn);
DataTable vTable = new DataTable();
vAdapter.Fill(vTable); //行数与PL Sql读取的一样,但都是空字符串
this.dataGridView1.DataSource = vTable;
//1.用DataReader的方式
var mCommand = new OracleCommand();
mCommand.Connection = conn;
mCommand.CommandText = sql1;
var tbResult = new DataTable("TB1");
try
{
conn.Open();
using (var reader = mCommand.ExecuteReader())
{
var nFieldCount = reader.FieldCount;
for (int intCounter = 0; intCounter < nFieldCount; ++intCounter)
{
tbResult.Columns.Add(reader.GetName(intCounter), reader.GetFieldType(intCounter));
}
var objValues = new object[nFieldCount];
while (reader.Read())
{
var t1 = reader.GetFieldType(0); //居然显示是String,但是却读不到字符串,PL/Sql显示是LONG类型
var arr1 = (byte[])reader[0]; //强制转换也不行,会报错:无法将类型为“System.String”的对象强制转换为类型“System.Byte[]
var b1 = reader.GetOracleBlob(0);
var s1 = reader.GetOracleString(0);
var sr = reader.GetStream(0);
}
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}