Devart Forums

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();