Geting list with asp.net, oracle stored procedure and dapper


IDbConnection db2 = new OracleConnection(connStr);
try
{

var p = new OracleDynamicParameters();
p.Add("i_user_id", userID, OracleMappingType.Varchar2, ParameterDirection.Input);
p.Add("o_recordset", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output);
var result = db.Query<MYDATATYPE>("my stored procedure name", p, commandType: CommandType.StoredProcedure);

var list = result.ToList();
}
catch (Exception ex)
{
Log.WriteInfo(ex);
throw;
}
finally
{
db2.Close();
}