Code: Select all
OracleCommand cmd = new OracleCommand("create table blobtest(k integer, v blob)", con);
cmd.ExecuteNonQuery();
cmd = new OracleCommand("insert into blobtest(k, v) values(:k, :v)", con);
cmd.Parameters.Add("k", 1);
cmd.Parameters.Add("v", new byte[13382]);
cmd.ExecuteNonQuery();
cmd = new OracleCommand("select k, v from blobtest", con);
OracleDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
object k = reader[0];
byte[] v = (byte[])reader[1];
}
reader.Close();
if this size is increased or decreased by one byte.
I think there are other critical sizes as i get the error on numerous
records in our production database.
The exception occurs only in direct mode.
Database servers testet are versions 9.2.0.8 and 11.1.0.6
As i'm currently switching from ODP.NET to OraDirect.NET
i would appreciate very much a solution to that problem.
Regards
Ingo Eichenseher