在C#中绑定Oracle阵列参数问题

using Oracle.ManagedDataAccess.Client;

// 创建Oracle连接对象
using (OracleConnection connection = new OracleConnection(connectionString))
{
    connection.Open();

    // 创建Oracle命令对象
    using (OracleCommand command = connection.CreateCommand())
    {
        command.CommandText = "SELECT * FROM table_name WHERE column_name IN (:values)";

        // 创建Oracle参数对象
        OracleParameter parameter = new OracleParameter();
        parameter.ParameterName = "values";
        parameter.OracleDbType = OracleDbType.Varchar2;
        parameter.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
        parameter.Value = new string[] { "value1", "value2", "value3" };

        // 将阵列参数对象添加到命令对象的参数集合中
        command.Parameters.Add(parameter);

        // 执行查询
        using (OracleDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                // 处理查询结果
            }
        }
    }
}