[ASP.NET] Oracle stored procedure recordset 반환하기

1. model 영역

public List<string> test2()
{
    OracleCommand cmd = new OracleCommand();
    cmd.Connection = this.dbcon;
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.CommandText = "sp_test";

    cmd.Parameters.Add("v_cursor", OracleType.Cursor).Direction = ParameterDirection.Output;

    OracleDataReader reader =  cmd.ExecuteReader();
    List<string> a = new List<string>();
    while(reader.Read()){
        a.Add(reader["mu_name"].ToString());
    }

    return a;
}

2. controller영역

public List<string> test2()
{
    OracleCommand cmd = new OracleCommand();
    cmd.Connection = this.dbcon;
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.CommandText = "sp_test";

    cmd.Parameters.Add("v_cursor", OracleType.Cursor).Direction = ParameterDirection.Output;

    OracleDataReader reader =  cmd.ExecuteReader();
    List<string> a = new List<string>();
    while(reader.Read()){
        a.Add(reader["mu_name"].ToString());
    }

    return a;
}