将OracleRefCursor转换为自定义C#对象的列表

using Oracle.ManagedDataAccess.Client;
using System;
using System.Collections.Generic;

public class CustomObject
{
    public string Property1 { get; set; }
    public int Property2 { get; set; }
    // 其他属性...
}

public class OracleRefCursorConverter
{
    public List<CustomObject> ConvertRefCursorToCustomObjectList(string connectionString, string procedureName)
    {
        List<CustomObject> customObjectList = new List<CustomObject>();

        using (OracleConnection connection = new OracleConnection(connectionString))
        {
            connection.Open();

            OracleCommand command = new OracleCommand(procedureName, connection);
            command.CommandType = System.Data.CommandType.StoredProcedure;

            // 添加RefCursor参数
            OracleParameter refCursorParam = new OracleParameter("refCursorParam", OracleDbType.RefCursor);
            refCursorParam.Direction = System.Data.ParameterDirection.ReturnValue;
            command.Parameters.Add(refCursorParam);

            // 执行存储过程
            OracleDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                CustomObject customObject = new CustomObject();
                customObject.Property1 = reader.GetString(0);
                customObject.Property2 = reader.GetInt32(1);
                // 设置其他属性...

                customObjectList.Add(customObject);
            }

            reader.Close();
        }

        return customObjectList;
    }
}