return BLOB ?????

return BLOB ?????

Postby expas » Fri 26 Aug 2005 00:05

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.
expas
 
Posts: 14
Joined: Wed 11 May 2005 00:09

Postby Paul » Mon 29 Aug 2005 09:06

Thank you for information. We reproduced your problem and fixed it. This fix will be included in the
next OraDirect .NET build.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Postby expas » Wed 07 Sep 2005 23:31

when you plan to take out build of OraDirect with this fix?
expas
 
Posts: 14
Joined: Wed 11 May 2005 00:09

Postby Paul » Fri 09 Sep 2005 06:58

We plane to issue next OraDirect .Net build next week.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle