Devart Forums

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;

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;