return BLOB ?????

[expas]

OraDirect last version for 1.1 framework
VS2005 beta 2

SQL Code:

Code: Select all

create or replace function TEST_F_BLOB return blob
is
  res blob;
begin
  select bin.blb into res 
    from t_testblob bin 
    where bin.id=1;

  return(res);
end TEST_F_BLOB;

C# code:

Code: Select all

OracleCommand cmd = new OracleCommand("TEST_F_BLOB", (OracleConnection)_cnn);
cmd.CommandType = CommandType.StoredProcedure;
OracleParameter p = new OracleParameter("res", OracleDbType.Blob);
p.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
object res = cmd.Parameters["res"].Value;

it crash on ExecuteNonQuery with:

Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

[Paul]

Thank you for information. We reproduced your problem and fixed it. This fix will be included in the
next OraDirect .NET build.

[expas]

when you plan to take out build of OraDirect with this fix?

[Paul]

We plane to issue next OraDirect .Net build next week.