OracleDataReader 取出LONG 类型字段为空字符串 c# netcore oracle long
项目中遇到此问题,找了很多解决方案,最后发现是读取时没有检测到数据导致,解决方案直接上代码
using (OracleConnection connection = new OracleConnection(”User Id=***;Password=*****;Data Source=127.0.0.1/***;“))
{
string SQLString =”select 字段 from 表名 where 条件“;
using (OracleCommand cmd1 = new OracleCommand(SQLString, connection))
{
try
{
connection.Open();
//command和检索sql文 关联
cmd1.InitialLONGFetchSize = -1;
OracleDataReader rdr = cmd1.ExecuteReader();
if (rdr.Read())