Oracle 参数化 OracleParameter 更新数据库案例

string strSql2 = string.Format(@"
        update cfuser
        set username= :i_username
        where userid= :i_userid
    ");

var parameters = new OracleParameter[] {
    new OracleParameter { ParameterName="i_username", OracleDbType=OracleDbType.Clob, Value= '张三'},
    new OracleParameter { ParameterName="i_userid", OracleDbType=OracleDbType.Long, Value= 1},

};

SqlAdapterHelp.ExecuteNonQuery(this.Adapter, strSql2, CommandType.Text, parameters);

        /// <summary>
        /// 执行不查询的数据库操作  
        /// </summary>
        /// <param name="adp"></param>
        /// <param name="commandText"></param>
        /// <param name="param"></param>
        /// <returns></returns>        
        public static int ExecuteNonQuery(DataAccessAdapter adp, string commandText, CommandType commandType, params OracleParameter[] param)
        {
            int result = 0;
            var conn = new OracleConnection(adp.ConnectionString);
            try
            {
                using (OracleCommand cmd = new OracleCommand(commandText, conn))
                {
                    try
                    {
                        cmd.CommandType = commandType;
                        if (param != null)
                        {
                            cmd.Parameters.AddRange(param);
                        }
                        conn.Open();
                        result = cmd.ExecuteNonQuery();
                    }
                    catch (Exception ex)
                    {
                        result = -1;
                        if (conn.State != ConnectionState.Closed)
                            conn.Close();

                        throw ex;
                    }
                }
            }
            finally
            {
                if (conn.State != ConnectionState.Closed)
                {
                    conn.Close();
                }
            }
            return result;
        }