Devart Forums

Code: Select all

create or replace procedure test_blob(p_blb out blob)
is
begin
  SELECT blb INTO p_blb FROM t_testblob b
	WHERE b.id = 1;
  EXCEPTION
 	WHEN OTHERS THEN
		p_blb := NULL;
end test_blob;

Code: Select all

OracleCommand cmd = new OracleCommand("test_blob", (OracleConnection)_cnn);
cmd.CommandType = CommandType.StoredProcedure;
OracleParameter p = new OracleParameter("blb", OracleDbType.Blob);
p.Direction = ParameterDirection.Output;
cmd.Parameters.Add(p);

cmd.ExecuteNonQuery();
byte[] lob0 = (byte[])cmd.Parameters["blb"].Value;