OracleConnection conn = Db.CreateConnection() as OracleConnection;
            conn.Open();
            OracleTransaction trans = conn.BeginTransaction() as OracleTransaction;
            OracleCommand cmd = Db.DbProviderFactory.CreateCommand() as OracleCommand;

            try
            {
                cmd.Transaction = trans;
                cmd.Connection = conn;
                cmd.CommandText = "GetTempBlob";
                //存储过程：GetTempBlob
                //"declare dpBlob blob; begin dbms_lob.createtemporary(dpBlob, false, 0); :tempblob := dpBlob; end;";
                //
                cmd.Parameters.Add(new OracleParameter("tmpBlob", OracleType.Blob)).Direction = ParameterDirection.Output;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.ExecuteNonQuery();
                OracleLob tmpBlob = (OracleLob)cmd.Parameters[0].Value;
                tmpBlob.BeginBatch(OracleLobOpenMode.ReadWrite);
                tmpBlob.Write(bytNR, 0, bytNR.Length);
                tmpBlob.EndBatch();

                //执行插入存储过程
                cmd.Parameters.Clear();
                cmd.CommandType = CommandType.StoredProcedure;
                //cmd.Transaction = trans;
                cmd.CommandText = "pkg_ManoeuvreScheme.Pro_SaveManoeuvreScheme";
                Db.AddInParameter(cmd, "v_guid", DbType.String, "1");
                Db.AddInParameter(cmd, "v_yxfamc", DbType.String, strYXFAMC);
                Db.AddInParameter(cmd, "v_dy", DbType.String, strDY);
                Db.AddInParameter(cmd, "v_bxsj", DbType.DateTime, dtBXSJ);
                Db.AddInParameter(cmd, "v_yxfanr", DbType.String, strYXFANR);
                Db.AddInParameter(cmd, "v_pj", DbType.String, strPJ);
                Db.AddInParameter(cmd, "v_bz", DbType.String, strBZ);
                Db.AddInParameter(cmd, "v_wdmc", DbType.String, strWDMC);
                Db.AddParameter(cmd, "v_nr", OracleType.Blob, bytNR.Length,
                    ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, tmpBlob);
                int ret = cmd.ExecuteNonQuery();

                trans.Commit();

                return ret;

            }
            catch (Exception ex)
            {
                trans.Rollback();
                Logger.Error(ex);
                throw ex;
            }
            finally
            {
                conn.Close();
            }