执行一个在C#中返回引用游标的oracle函数

using Oracle.DataAccess.Client; // 或者使用Oracle.ManagedDataAccess.Client

public OracleDataReader ExecuteOracleFunction()
{
    string connectionString = "Data Source=your_database;User Id=your_username;Password=your_password;";
    OracleConnection connection = new OracleConnection(connectionString);
    connection.Open();

    OracleCommand command = new OracleCommand("your_function_name", connection);
    command.CommandType = CommandType.StoredProcedure;

    OracleParameter returnCursor = new OracleParameter();
    returnCursor.Direction = ParameterDirection.ReturnValue;
    returnCursor.OracleDbType = OracleDbType.RefCursor;

    command.Parameters.Add(returnCursor);

    command.ExecuteNonQuery();

    OracleDataReader reader = ((OracleRefCursor)returnCursor.Value).GetDataReader();

    // 读取引用游标中的数据
    while (reader.Read())
    {
        // 处理数据
    }

    reader.Close();
    connection.Close();

    return reader;
}