class BlobDemo
{
    private static readonly string ConnectionString =
           "Data Source=Tcco;User ID=scott;Password=tiger;";
    public void AddWithProcedure(string file)
        {
            if (File.Exists(file) == false)
            {
                return;
            }
            string strSql = "AddPhoto";
            using (OracleConnection conn = new OracleConnection(ConnectionString))
            {
                conn.Open();
                OracleCommand cmd = new OracleCommand(strSql, conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add(new OracleParameter("vPhoto", OracleType.Blob));
                cmd.Parameters[0].Value = File.ReadAllBytes(file);//A
                cmd.ExecuteNonQuery();
            }
        }
    //方法1
    public void AddWithSqlText(string file)
        {
            if (File.Exists(file) == false)
            {
                return;
            }
            //string strSql = "begin insert into blobdemo(Photo) values(:Photo);end;";//B
            string strSql = "insert into blobdemo(Pno,Photo) values(pno.nextval,:Photo)";using (OracleConnection conn = new OracleConnection(ConnectionString))
            {
                conn.Open();
                OracleCommand cmd = new OracleCommand(strSql, conn);
                cmd.Parameters.Add(new OracleParameter(":Photo", OracleType.Blob));
                cmd.Parameters[0].Value = File.ReadAllBytes(file);
                cmd.ExecuteNonQuery();
            }
        }
    //方法2
    public void AddWithProcedure2(string file)
        {
            if (File.Exists(file) == false)
            {
                return;
            }
            string strSql = "AddPhoto";
            using (OracleConnection conn = new OracleConnection(ConnectionString))
            {
                conn.Open();
                OracleCommand cmd = new OracleCommand(strSql, conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add(new OracleParameter("vPhoto", OracleType.Blob));byte[] arr = null;
                using (FileStream fs = new FileStream(file, FileMode.Open, FileAccess.Read, FileShare.Read))
                {
                    arr = new byte[fs.Length];
                    fs.Read(arr, 0, arr.Length);
                }
                //生成OracleLob类型
                OracleCommand cmd2 = conn.CreateCommand();

                OracleTransaction tx;
                tx 

--创建表
create table BLOBDEMO
(
  PHOTO BLOB,
  PNO   NUMBER(18)
)
--创建序列
create sequence PNO
minvalue 1
maxvalue 9999999999999999999999999
start with 27
increment by 1
nocache;
--创建存储过程
create or replace procedure AddPhoto
(vPhoto in blob)
is
l_pno number(18);
begin
select pno.nextval into l_pno from dual;
insert into BlobDemo(pno,Photo) values(l_pno,vPhoto);
end;