clob类型字段最大存储长度_oracle clob长度 Oracle中Clob与Blob字段的读取-程序员宅基地

技术标签: clob类型字段最大存储长度  

Oracle中若以字符串的形式写入数据到Clob字段中,默认的长度为4000,最大可存储4G。

直接将字符串写入Clob字段中,则最大可写4000个字节;若要写入大的字符数据,可以将字符数据以二进制流的形式写入。

写入Clob(Blob代码):

OracleConnection conn = new

OracleConnection(GetConfigUserConnectionString());

conn.Open();

OracleTransaction tran = conn.BeginTransaction();

string id = string.Empty;

OracleCommand command = null;

try

{

command = new OracleCommand();

command.Connection = conn;

double scale = 0;

if (ct.Scale.IndexOf(":") == -1)

{

scale = BasicOperate.GetDouble(ct.Scale, true);

}

else

{

scale = BasicOperate.GetDouble(ct.Scale.Substring(ct.Scale

.IndexOf(":") + 1), true);

}

//在插入时先存一个空的empty_clob()[empty_blob()]

command.CommandText = string.Format(@"insert into

chart(chartname,charttype,source,scale,producttime ,"

+"xml_definition)

values('{0}','{1}','{2}',{3},'{4}',empty_clob()) "

+"returning chartid into :rid",

ct.ChartName, ct.ChartType, ct.Source, scale, ct.ProductTime,

ct.xmlDefinition);

command.Parameters.Add("rid", OracleDbType.Varchar2,

32).Direction = ParameterDirection.Output;

command.ExecuteNonQuery();

id = command.Parameters["rid"].Value.ToString();

//读入clob字段进行编辑

command.CommandText = string.Format("select xml_definition from

chart where chartid='{0}' for update", id);

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读入二进制对性

clob.Erase();//清空其中的数据

clob.Position = 0;

clob.BeginChunkWrite();//开始写入

int buffersize = 100;

int retval = 0;

byte[] bts = new byte[buffersize];

//将字符串序列化为二进制流

MemoryStream stream = new MemoryStream();

BinaryFormatter formatter = new BinaryFormatter();

formatter.Serialize(stream, ct.xmlDefinition);

//将二进制流写入Clob字符中

stream.Seek(0, SeekOrigin.Begin);

retval = stream.Read(bts, 0, buffersize);

while (retval == buffersize)

{

clob.Write(bts, 0, buffersize);

retval = stream.Read(bts, 0, buffersize);

}

clob.Write(bts, 0, 100);

clob.EndChunkWrite();//结束写入

clob.Flush();//刷新

clob.Close();//关闭

}

reader.Close();

}

tran.Commit();

}

catch (Exception ex)

{

tran.Rollback();

//throw new Exception(ex.Message);

}

finally

{

if (conn.State == ConnectionState.Open)

{

conn.Close();

}

}

读取Clob(blob)字段:

。。。

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读取二进制字段

clob.Position = 0;//指向起点

byte[] tt = new byte[clob.Length];

clob.Read(tt, 0, (int)clob.Length);//将Clob读为二进制数据

MemoryStream ms = new MemoryStream(tt);

BinaryFormatter bb = new BinaryFormatter();

object oo = bb.Deserialize(ms);//反序列化取出字符数据

}}

oracle clob长度 Oracle中Clob与Blob字段的读取

作者:互联网 来源:互联网 点击数:

Oracle中若以字符串的形式写入数据到Clob字段中,默认的长度为4000,最大可存储4G。

直接将字符串写入Clob字段中,则最大可写4000个字节;若要写入大的字符数据,可以将字符数据以二进制流的形式写入。

写入Clob(Blob代码):

OracleConnection conn = new

OracleConnection(GetConfigUserConnectionString());

conn.Open();

OracleTransaction tran = conn.BeginTransaction();

string id = string.Empty;

OracleCommand command = null;

try

{

command = new OracleCommand();

command.Connection = conn;

double scale = 0;

if (ct.Scale.IndexOf(":") == -1)

{

scale = BasicOperate.GetDouble(ct.Scale, true);

}

else

{

scale = BasicOperate.GetDouble(ct.Scale.Substring(ct.Scale

.IndexOf(":") + 1), true);

}

//在插入时先存一个空的empty_clob()[empty_blob()]

command.CommandText = string.Format(@"insert into

chart(chartname,charttype,source,scale,producttime ,"

+"xml_definition)

values('{0}','{1}','{2}',{3},'{4}',empty_clob()) "

+"returning chartid into :rid",

ct.ChartName, ct.ChartType, ct.Source, scale, ct.ProductTime,

ct.xmlDefinition);

command.Parameters.Add("rid", OracleDbType.Varchar2,

32).Direction = ParameterDirection.Output;

command.ExecuteNonQuery();

id = command.Parameters["rid"].Value.ToString();

//读入clob字段进行编辑

command.CommandText = string.Format("select xml_definition from

chart where chartid='{0}' for update", id);

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读入二进制对性

clob.Erase();//清空其中的数据

clob.Position = 0;

clob.BeginChunkWrite();//开始写入

int buffersize = 100;

int retval = 0;

byte[] bts = new byte[buffersize];

//将字符串序列化为二进制流

MemoryStream stream = new MemoryStream();

BinaryFormatter formatter = new BinaryFormatter();

formatter.Serialize(stream, ct.xmlDefinition);

//将二进制流写入Clob字符中

stream.Seek(0, SeekOrigin.Begin);

retval = stream.Read(bts, 0, buffersize);

while (retval == buffersize)

{

clob.Write(bts, 0, buffersize);

retval = stream.Read(bts, 0, buffersize);

}

clob.Write(bts, 0, 100);

clob.EndChunkWrite();//结束写入

clob.Flush();//刷新

clob.Close();//关闭

}

reader.Close();

}

tran.Commit();

}

catch (Exception ex)

{

tran.Rollback();

//throw new Exception(ex.Message);

}

finally

{

if (conn.State == ConnectionState.Open)

{

conn.Close();

}

}

读取Clob(blob)字段:

。。。

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读取二进制字段

clob.Position = 0;//指向起点

byte[] tt = new byte[clob.Length];

clob.Read(tt, 0, (int)clob.Length);//将Clob读为二进制数据

MemoryStream ms = new MemoryStream(tt);

BinaryFormatter bb = new BinaryFormatter();

object oo = bb.Deserialize(ms);//反序列化取出字符数据

}}

oracle clob长度 Oracle中Clob与Blob字段的读取

作者:互联网 来源:互联网 点击数:

Oracle中若以字符串的形式写入数据到Clob字段中,默认的长度为4000,最大可存储4G。

直接将字符串写入Clob字段中,则最大可写4000个字节;若要写入大的字符数据,可以将字符数据以二进制流的形式写入。

写入Clob(Blob代码):

OracleConnection conn = new

OracleConnection(GetConfigUserConnectionString());

conn.Open();

OracleTransaction tran = conn.BeginTransaction();

string id = string.Empty;

OracleCommand command = null;

try

{

command = new OracleCommand();

command.Connection = conn;

double scale = 0;

if (ct.Scale.IndexOf(":") == -1)

{

scale = BasicOperate.GetDouble(ct.Scale, true);

}

else

{

scale = BasicOperate.GetDouble(ct.Scale.Substring(ct.Scale

.IndexOf(":") + 1), true);

}

//在插入时先存一个空的empty_clob()[empty_blob()]

command.CommandText = string.Format(@"insert into

chart(chartname,charttype,source,scale,producttime ,"

+"xml_definition)

values('{0}','{1}','{2}',{3},'{4}',empty_clob()) "

+"returning chartid into :rid",

ct.ChartName, ct.ChartType, ct.Source, scale, ct.ProductTime,

ct.xmlDefinition);

command.Parameters.Add("rid", OracleDbType.Varchar2,

32).Direction = ParameterDirection.Output;

command.ExecuteNonQuery();

id = command.Parameters["rid"].Value.ToString();

//读入clob字段进行编辑

command.CommandText = string.Format("select xml_definition from

chart where chartid='{0}' for update", id);

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读入二进制对性

clob.Erase();//清空其中的数据

clob.Position = 0;

clob.BeginChunkWrite();//开始写入

int buffersize = 100;

int retval = 0;

byte[] bts = new byte[buffersize];

//将字符串序列化为二进制流

MemoryStream stream = new MemoryStream();

BinaryFormatter formatter = new BinaryFormatter();

formatter.Serialize(stream, ct.xmlDefinition);

//将二进制流写入Clob字符中

stream.Seek(0, SeekOrigin.Begin);

retval = stream.Read(bts, 0, buffersize);

while (retval == buffersize)

{

clob.Write(bts, 0, buffersize);

retval = stream.Read(bts, 0, buffersize);

}

clob.Write(bts, 0, 100);

clob.EndChunkWrite();//结束写入

clob.Flush();//刷新

clob.Close();//关闭

}

reader.Close();

}

tran.Commit();

}

catch (Exception ex)

{

tran.Rollback();

//throw new Exception(ex.Message);

}

finally

{

if (conn.State == ConnectionState.Open)

{

conn.Close();

}

}

读取Clob(blob)字段:

。。。

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读取二进制字段

clob.Position = 0;//指向起点

byte[] tt = new byte[clob.Length];

clob.Read(tt, 0, (int)clob.Length);//将Clob读为二进制数据

MemoryStream ms = new MemoryStream(tt);

BinaryFormatter bb = new BinaryFormatter();

object oo = bb.Deserialize(ms);//反序列化取出字符数据

}}

oracle clob长度 Oracle中Clob与Blob字段的读取

作者:互联网 来源:互联网 点击数:

Oracle中若以字符串的形式写入数据到Clob字段中,默认的长度为4000,最大可存储4G。

直接将字符串写入Clob字段中,则最大可写4000个字节;若要写入大的字符数据,可以将字符数据以二进制流的形式写入。

写入Clob(Blob代码):

OracleConnection conn = new

OracleConnection(GetConfigUserConnectionString());

conn.Open();

OracleTransaction tran = conn.BeginTransaction();

string id = string.Empty;

OracleCommand command = null;

try

{

command = new OracleCommand();

command.Connection = conn;

double scale = 0;

if (ct.Scale.IndexOf(":") == -1)

{

scale = BasicOperate.GetDouble(ct.Scale, true);

}

else

{

scale = BasicOperate.GetDouble(ct.Scale.Substring(ct.Scale

.IndexOf(":") + 1), true);

}

//在插入时先存一个空的empty_clob()[empty_blob()]

command.CommandText = string.Format(@"insert into

chart(chartname,charttype,source,scale,producttime ,"

+"xml_definition)

values('{0}','{1}','{2}',{3},'{4}',empty_clob()) "

+"returning chartid into :rid",

ct.ChartName, ct.ChartType, ct.Source, scale, ct.ProductTime,

ct.xmlDefinition);

command.Parameters.Add("rid", OracleDbType.Varchar2,

32).Direction = ParameterDirection.Output;

command.ExecuteNonQuery();

id = command.Parameters["rid"].Value.ToString();

//读入clob字段进行编辑

command.CommandText = string.Format("select xml_definition from

chart where chartid='{0}' for update", id);

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读入二进制对性

clob.Erase();//清空其中的数据

clob.Position = 0;

clob.BeginChunkWrite();//开始写入

int buffersize = 100;

int retval = 0;

byte[] bts = new byte[buffersize];

//将字符串序列化为二进制流

MemoryStream stream = new MemoryStream();

BinaryFormatter formatter = new BinaryFormatter();

formatter.Serialize(stream, ct.xmlDefinition);

//将二进制流写入Clob字符中

stream.Seek(0, SeekOrigin.Begin);

retval = stream.Read(bts, 0, buffersize);

while (retval == buffersize)

{

clob.Write(bts, 0, buffersize);

retval = stream.Read(bts, 0, buffersize);

}

clob.Write(bts, 0, 100);

clob.EndChunkWrite();//结束写入

clob.Flush();//刷新

clob.Close();//关闭

}

reader.Close();

}

tran.Commit();

}

catch (Exception ex)

{

tran.Rollback();

//throw new Exception(ex.Message);

}

finally

{

if (conn.State == ConnectionState.Open)

{

conn.Close();

}

}

读取Clob(blob)字段:

。。。

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读取二进制字段

clob.Position = 0;//指向起点

byte[] tt = new byte[clob.Length];

clob.Read(tt, 0, (int)clob.Length);//将Clob读为二进制数据

MemoryStream ms = new MemoryStream(tt);

BinaryFormatter bb = new BinaryFormatter();

object oo = bb.Deserialize(ms);//反序列化取出字符数据

}}

oracle clob长度 Oracle中Clob与Blob字段的读取

作者:互联网 来源:互联网 点击数:

Oracle中若以字符串的形式写入数据到Clob字段中,默认的长度为4000,最大可存储4G。

直接将字符串写入Clob字段中,则最大可写4000个字节;若要写入大的字符数据,可以将字符数据以二进制流的形式写入。

写入Clob(Blob代码):

OracleConnection conn = new

OracleConnection(GetConfigUserConnectionString());

conn.Open();

OracleTransaction tran = conn.BeginTransaction();

string id = string.Empty;

OracleCommand command = null;

try

{

command = new OracleCommand();

command.Connection = conn;

double scale = 0;

if (ct.Scale.IndexOf(":") == -1)

{

scale = BasicOperate.GetDouble(ct.Scale, true);

}

else

{

scale = BasicOperate.GetDouble(ct.Scale.Substring(ct.Scale

.IndexOf(":") + 1), true);

}

//在插入时先存一个空的empty_clob()[empty_blob()]

command.CommandText = string.Format(@"insert into

chart(chartname,charttype,source,scale,producttime ,"

+"xml_definition)

values('{0}','{1}','{2}',{3},'{4}',empty_clob()) "

+"returning chartid into :rid",

ct.ChartName, ct.ChartType, ct.Source, scale, ct.ProductTime,

ct.xmlDefinition);

command.Parameters.Add("rid", OracleDbType.Varchar2,

32).Direction = ParameterDirection.Output;

command.ExecuteNonQuery();

id = command.Parameters["rid"].Value.ToString();

//读入clob字段进行编辑

command.CommandText = string.Format("select xml_definition from

chart where chartid='{0}' for update", id);

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读入二进制对性

clob.Erase();//清空其中的数据

clob.Position = 0;

clob.BeginChunkWrite();//开始写入

int buffersize = 100;

int retval = 0;

byte[] bts = new byte[buffersize];

//将字符串序列化为二进制流

MemoryStream stream = new MemoryStream();

BinaryFormatter formatter = new BinaryFormatter();

formatter.Serialize(stream, ct.xmlDefinition);

//将二进制流写入Clob字符中

stream.Seek(0, SeekOrigin.Begin);

retval = stream.Read(bts, 0, buffersize);

while (retval == buffersize)

{

clob.Write(bts, 0, buffersize);

retval = stream.Read(bts, 0, buffersize);

}

clob.Write(bts, 0, 100);

clob.EndChunkWrite();//结束写入

clob.Flush();//刷新

clob.Close();//关闭

}

reader.Close();

}

tran.Commit();

}

catch (Exception ex)

{

tran.Rollback();

//throw new Exception(ex.Message);

}

finally

{

if (conn.State == ConnectionState.Open)

{

conn.Close();

}

}

读取Clob(blob)字段:

。。。

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读取二进制字段

clob.Position = 0;//指向起点

byte[] tt = new byte[clob.Length];

clob.Read(tt, 0, (int)clob.Length);//将Clob读为二进制数据

MemoryStream ms = new MemoryStream(tt);

BinaryFormatter bb = new BinaryFormatter();

object oo = bb.Deserialize(ms);//反序列化取出字符数据

}}

oracle clob长度 Oracle中Clob与Blob字段的读取

作者:互联网 来源:互联网 点击数:

Oracle中若以字符串的形式写入数据到Clob字段中,默认的长度为4000,最大可存储4G。

直接将字符串写入Clob字段中,则最大可写4000个字节;若要写入大的字符数据,可以将字符数据以二进制流的形式写入。

写入Clob(Blob代码):

OracleConnection conn = new

OracleConnection(GetConfigUserConnectionString());

conn.Open();

OracleTransaction tran = conn.BeginTransaction();

string id = string.Empty;

OracleCommand command = null;

try

{

command = new OracleCommand();

command.Connection = conn;

double scale = 0;

if (ct.Scale.IndexOf(":") == -1)

{

scale = BasicOperate.GetDouble(ct.Scale, true);

}

else

{

scale = BasicOperate.GetDouble(ct.Scale.Substring(ct.Scale

.IndexOf(":") + 1), true);

}

//在插入时先存一个空的empty_clob()[empty_blob()]

command.CommandText = string.Format(@"insert into

chart(chartname,charttype,source,scale,producttime ,"

+"xml_definition)

values('{0}','{1}','{2}',{3},'{4}',empty_clob()) "

+"returning chartid into :rid",

ct.ChartName, ct.ChartType, ct.Source, scale, ct.ProductTime,

ct.xmlDefinition);

command.Parameters.Add("rid", OracleDbType.Varchar2,

32).Direction = ParameterDirection.Output;

command.ExecuteNonQuery();

id = command.Parameters["rid"].Value.ToString();

//读入clob字段进行编辑

command.CommandText = string.Format("select xml_definition from

chart where chartid='{0}' for update", id);

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读入二进制对性

clob.Erase();//清空其中的数据

clob.Position = 0;

clob.BeginChunkWrite();//开始写入

int buffersize = 100;

int retval = 0;

byte[] bts = new byte[buffersize];

//将字符串序列化为二进制流

MemoryStream stream = new MemoryStream();

BinaryFormatter formatter = new BinaryFormatter();

formatter.Serialize(stream, ct.xmlDefinition);

//将二进制流写入Clob字符中

stream.Seek(0, SeekOrigin.Begin);

retval = stream.Read(bts, 0, buffersize);

while (retval == buffersize)

{

clob.Write(bts, 0, buffersize);

retval = stream.Read(bts, 0, buffersize);

}

clob.Write(bts, 0, 100);

clob.EndChunkWrite();//结束写入

clob.Flush();//刷新

clob.Close();//关闭

}

reader.Close();

}

tran.Commit();

}

catch (Exception ex)

{

tran.Rollback();

//throw new Exception(ex.Message);

}

finally

{

if (conn.State == ConnectionState.Open)

{

conn.Close();

}

}

读取Clob(blob)字段:

。。。

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读取二进制字段

clob.Position = 0;//指向起点

byte[] tt = new byte[clob.Length];

clob.Read(tt, 0, (int)clob.Length);//将Clob读为二进制数据

MemoryStream ms = new MemoryStream(tt);

BinaryFormatter bb = new BinaryFormatter();

object oo = bb.Deserialize(ms);//反序列化取出字符数据

}}

oracle clob长度 Oracle中Clob与Blob字段的读取

作者:互联网 来源:互联网 点击数:

Oracle中若以字符串的形式写入数据到Clob字段中,默认的长度为4000,最大可存储4G。

直接将字符串写入Clob字段中,则最大可写4000个字节;若要写入大的字符数据,可以将字符数据以二进制流的形式写入。

写入Clob(Blob代码):

OracleConnection conn = new

OracleConnection(GetConfigUserConnectionString());

conn.Open();

OracleTransaction tran = conn.BeginTransaction();

string id = string.Empty;

OracleCommand command = null;

try

{

command = new OracleCommand();

command.Connection = conn;

double scale = 0;

if (ct.Scale.IndexOf(":") == -1)

{

scale = BasicOperate.GetDouble(ct.Scale, true);

}

else

{

scale = BasicOperate.GetDouble(ct.Scale.Substring(ct.Scale

.IndexOf(":") + 1), true);

}

//在插入时先存一个空的empty_clob()[empty_blob()]

command.CommandText = string.Format(@"insert into

chart(chartname,charttype,source,scale,producttime ,"

+"xml_definition)

values('{0}','{1}','{2}',{3},'{4}',empty_clob()) "

+"returning chartid into :rid",

ct.ChartName, ct.ChartType, ct.Source, scale, ct.ProductTime,

ct.xmlDefinition);

command.Parameters.Add("rid", OracleDbType.Varchar2,

32).Direction = ParameterDirection.Output;

command.ExecuteNonQuery();

id = command.Parameters["rid"].Value.ToString();

//读入clob字段进行编辑

command.CommandText = string.Format("select xml_definition from

chart where chartid='{0}' for update", id);

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读入二进制对性

clob.Erase();//清空其中的数据

clob.Position = 0;

clob.BeginChunkWrite();//开始写入

int buffersize = 100;

int retval = 0;

byte[] bts = new byte[buffersize];

//将字符串序列化为二进制流

MemoryStream stream = new MemoryStream();

BinaryFormatter formatter = new BinaryFormatter();

formatter.Serialize(stream, ct.xmlDefinition);

//将二进制流写入Clob字符中

stream.Seek(0, SeekOrigin.Begin);

retval = stream.Read(bts, 0, buffersize);

while (retval == buffersize)

{

clob.Write(bts, 0, buffersize);

retval = stream.Read(bts, 0, buffersize);

}

clob.Write(bts, 0, 100);

clob.EndChunkWrite();//结束写入

clob.Flush();//刷新

clob.Close();//关闭

}

reader.Close();

}

tran.Commit();

}

catch (Exception ex)

{

tran.Rollback();

//throw new Exception(ex.Message);

}

finally

{

if (conn.State == ConnectionState.Open)

{

conn.Close();

}

}

读取Clob(blob)字段:

。。。

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob =

reader.GetOracleClob(0);//读取二进制字段

clob.Position = 0;//指向起点

byte[] tt = new byte[clob.Length];

clob.Read(tt, 0, (int)clob.Length);//将Clob读为二进制数据

MemoryStream ms = new MemoryStream(tt);

BinaryFormatter bb = new BinaryFormatter();

object oo = bb.Deserialize(ms);//反序列化取出字符数据

}}

Oracle中若以字符串的形式写入数据到Clob字段中,默认的长度为4000,最大可存储4G。

直接将字符串写入Clob字段中,则最大可写4000个字节;若要写入大的字符数据,可以将字符数据以二进制流的形式写入。

写入Clob(Blob代码):

OracleConnection conn = new

OracleConnection(GetConfigUserConnectionString());

conn.Open();

OracleTransaction tran = conn.BeginTransaction();

string id = string.Empty;

OracleCommand command = null;

try

{

command = new OracleCommand();

command.Connection = conn;

double scale = 0;

if (ct.Scale.IndexOf(":") == -1)

{

scale = BasicOperate.GetDouble(ct.Scale, true);

}

else

{

scale = BasicOperate.GetDouble(ct.Scale.Substring(ct.Scale

.IndexOf(":") + 1), true);

}

//在插入时先存一个空的empty_clob()[empty_blob()]

command.CommandText = string.Format(@"insert into

chart(chartname,charttype,source,scale,producttime ,"

+"xml_definition)

values('{0}','{1}','{2}',{3},'{4}',empty_clob()) "

+"returning chartid into :rid",

ct.ChartName, ct.ChartType, ct.Source, scale, ct.ProductTime,

ct.xmlDefinition);

command.Parameters.Add("rid", OracleDbType.Varchar2,

32).Direction = ParameterDirection.Output;

command.ExecuteNonQuery();

id = command.Parameters["rid"].Value.ToString();

//读入clob字段进行编辑

command.CommandText = string.Format("select xml_definition

from chart where chartid='{0}' for update", id);

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob = reader.GetOracleClob(0);//读入二进制对性

clob.Erase();//清空其中的数据

clob.Position = 0;

clob.BeginChunkWrite();//开始写入

int buffersize = 100;

int retval = 0;

byte[] bts = new byte[buffersize];

//将字符串序列化为二进制流

MemoryStream stream = new MemoryStream();

BinaryFormatter formatter = new BinaryFormatter();

formatter.Serialize(stream, ct.xmlDefinition);

//将二进制流写入Clob字符中

stream.Seek(0, SeekOrigin.Begin);

retval = stream.Read(bts, 0, buffersize);

while (retval == buffersize)

{

clob.Write(bts, 0, buffersize);

retval = stream.Read(bts, 0, buffersize);

}

clob.Write(bts, 0, 100);

clob.EndChunkWrite();//结束写入

clob.Flush();//刷新

clob.Close();//关闭

}

reader.Close();

}

tran.Commit();

}

catch (Exception ex)

{

tran.Rollback();

//throw new Exception(ex.Message);

}

finally

{

if (conn.State == ConnectionState.Open)

{

conn.Close();

}

}

读取Clob(blob)字段:

。。。

using (OracleDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

OracleClob clob = reader.GetOracleClob(0);//读取二进制字段

clob.Position = 0;//指向起点

byte[] tt = new byte[clob.Length];

clob.Read(tt, 0, (int)clob.Length);//将Clob读为二进制数据

MemoryStream ms = new MemoryStream(tt);

BinaryFormatter bb = new BinaryFormatter();

object oo = bb.Deserialize(ms);//反序列化取出字符数据

}}

版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/weixin_39992760/article/details/111516438

智能推荐

Flink CDC 系列 - 同步 MySQL 分库分表,构建 Iceberg 实时数据湖_flink cdc 分库分表-程序员宅基地

文章浏览阅读3.5k次。在 OLTP 系统中,为了解决单表数据量大的问题,通常采用分库分表的方式将单个大表进行拆分以提高系统的吞吐量。但是为了方便数据分析,通常需要将分库分表拆分出的表在同步到数据仓库、数据湖时,再合并成一个大表。这篇教程将展示如何使用 Flink CDC 构建实时数据湖来应对这种场景,本教程的演示基于 Docker,只涉及 SQL,无需一行 Java/Scala 代码,也无需安装 IDE,你可以很方便地在自己的电脑上完成本教程的全部内容。接下来将以数据从 MySQL 同步到 Iceberg[1] 为例_flink cdc 分库分表

(1.2)、MyBatis介绍及其环境搭建-程序员宅基地

文章浏览阅读197次。MyBatis介绍:数据库持久化概念:数据库持久化将内存中的数据模型转换为存储模型,以及将存储模型转换为内存中数据模型的统称。例如,文件的存储、文件的存储、数据的读取等都是数据持久化操作。数据模型可以是任何数据结构或对象模型,存储模型可以是关系模型、XML、二进制流等。MyBatis框架简介:  MyBatis的前身是iBatis,本是Apche的一个开源项目,2010年这个项目有..._mybatis介绍及其环境搭建

微信js浏览器查看网络状态_微信游览器判断网络状态-程序员宅基地

文章浏览阅读3k次。window.onload = function() { document.addEventListener("WeixinJSBridgeReady", onWeixinReady, false); }function onWeixinReady() { WeixinJSBridge.invoke('getNetworkType',{}, function(e){ WeixinJSBr_微信游览器判断网络状态

堆溢出问题快速调试_reuse delay of heap object-程序员宅基地

文章浏览阅读349次。首先来看下问题代码,这里最后的空字符发生了溢出。来看一下出现的问题以及如何调试。上面写明是堆链中第41个堆块且地址在0x00382a700出发生了错误。这种情况下别急着终止,点击重试就会断在出问题的位置。点重试后断到了这里往上拉一拉,寻找函数名,或者直接查看调用堆栈发现是断在_free_dbg函数中,这个函数是free()的底层,所以可以断定一定是释放的时候出了问题直接在free()函数上下断点然后运行过去,发现第41块堆块的下溢标志受损了。就是strcpy导致的。_reuse delay of heap object

Java 知识点总结篇(3)_java程序设计基础第三章知识总结 site:blog.csdn.net-程序员宅基地

文章浏览阅读298次。抽象类使用规则 abstract定义抽象类;abstract定义抽象方法,只有声明,不需要实现;包含抽象方法的类是抽象类;抽象类中可以包含普通方法,也可以没有抽象方法;抽象类不能直接创建,可以定义引用变量; 接口定义:一种特殊的类,由全局常量和公共的抽象方法所组成;类是一种具体实现体,而接口定义了某一批类所要遵守的规范,接口不关心这些类的内部数据,也不关..._java程序设计基础第三章知识总结 site:blog.csdn.net

如何应对保研面试_半导体所保研面试-程序员宅基地

文章浏览阅读6.9k次。保研只有复试,没有初试,因此,几分钟的面试就可以完全决定自己的命运。因此,这一环是最重要的环节。  首先,在面试前,应该和自己报考的老师进行沟通,以获得一个较好的印象,同时了解将来读研时的大概内容。笔者在面试前一天,与报考的导师进行了约20分钟的交流,就向他大概说了下自己的学术志向,并问了老师的具体研究方向与要求。  很多学校都要求笔试,先谈一下笔试要点(只能以中科院半导体研究所为_半导体所保研面试

随便推点

Linux系统中rpm命令安装软件,报错:This program may be freely redistributed under the terms of the GNU GPL-程序员宅基地

文章浏览阅读1.8w次。遇到问题:This program may be freely redistributed under the terms of the GNU GPLUsage: rpm {–help}rpm {–version}解决办法:rpm -ivh XXX.rpm –nodeps –force注:转载至 https://blog.csdn.net/wanglf1986/article/..._this program may be freely redistributed under the terms of the gnu gpl

(五)synchronized和ReentrantLock_用synchnized 和reentrulock-程序员宅基地

文章浏览阅读394次。一、synchronized简介synchronized是关键字,用来实现同步锁,非公平锁,可重入锁公平锁:是按照锁申请的顺序来获取锁,线程直接进入同步队列中排队,队列中的第一个线程才能获得到锁。非公平锁:非公平锁是线程申请锁时,直接尝试加锁,获取不到才会进入到同步队列排队。如果此时该线程刚好获取到了锁,那么它不需要因为队列中有其他线程在排队而阻塞,省去了CPU唤醒该线程的开销。而对于已经在同步队列中的线程,仍然是按照先进先出的公平规则获取锁~什么是可重入?同一个线程可以反复获取锁多次,_用synchnized 和reentrulock

abaqus与matlab联合仿真_matlab调用abaqus-程序员宅基地

文章浏览阅读1.2w次,点赞7次,收藏80次。abaqus与matlab联合仿真 取材于2020.11的资料,文档整理于2021.2.7引:启动abaqus license如果运行abaqus报错如下图:则点击abaqus licensing,选择第四个【Start/Stop/Reread】,点击第一个按钮【Start Server】,下方显示框中显示【Server Start Successful.】,再次打开abaqus ACE即可,如果还是报错就再开一次。abaqus licensing界面:正常打开的abaqus提示框:_matlab调用abaqus

Messenger进行IPC通信_messenger ipc dead 检测-程序员宅基地

文章浏览阅读213次。Messenger进行IPC通信实例_messenger ipc dead 检测

课程学习--算法总结:编程基础(第1期)--ACM模式基本输入输出_acm模式如何编程-程序员宅基地

文章浏览阅读110次。一、 基本定义import java.util.*;import java.io.*;/** * @className: Main * @description: ACM模式相关模板 * @author: Charlie * @create: 2022/4/25 10:56 */public class Main { public static void main(String[] args) { Scanner scanner = new Scanner(Sys_acm模式如何编程

phpcms V9支持采集https网页的修改方法_phpcms v9 ssl-程序员宅基地

文章浏览阅读316次。不知道有没有小伙伴在使用PHPCMS V9系统的时候,在采集网页内容时,有些网页可以采集,有些网页不能采集,经过分析,小编得出结论是,http前缀的网页是可以采集的,但是通过SSL加密的HTTPS网页就无法采集,怎么办呢?_phpcms v9 ssl

推荐文章

热门文章

相关标签