oracle stored procedure returning cursor

[martinRocks]

I just found your package and I think it will make my code read a ton better. Right now, my code looks like the first code block. It works fine, but I would like to make my code look the second code block, but it can't seem to figure out how to set the returning cursor. I think I'm close in the second code block. As you can see, I'm stuck in an oracle database where every stored procedure returns a refcursor.

List<Dto> data;
var connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
using (var connection = new OracleConnection(connStr))
{
     var values = new OracleDynamicParameters();
     values.Add("i_uic", Uic, OracleMappingType.Varchar2, ParameterDirection.Input);
     values.Add("o_cur", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output);

     data = connection.Query<Dto>("jcn_exports.get_work_notifications", values, commandType: CommandType.StoredProcedure).ToList();
}

List<Dto> data;
var connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
using (var connection = new OracleConnection(connStr))
{
     var ocur = new OracleParameter("o_cur", OracleDbType.RefCursor, ParameterDirection.Output);
     var query = connection.SqlBuilder(
                    new InterpolatedSqlBuilderOptions(){DatabaseParameterSymbol = ":"},
                    $"jcn_exports.get_work_notifications({Uic}, {ocur})");
     data = query.Query<Dto>().ToList();
}

[martinRocks]

I tried this to and it also does NOT work.

List<Dto> data;
var connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
using (var connection = new OracleConnection(connStr))
{
    var options = new InterpolatedSqlBuilderOptions()
    {
        DatabaseParameterSymbol = ":"
    };
    var query = connection.SqlBuilder(options, $"jcn_exports.get_work_notifications")
        .AddParameter("i_uic", Uic, DbType.String, ParameterDirection.Input)
        .AddParameter("o_cur", direction: ParameterDirection.Output)
        .Build();
    var xx = query.Execute(commandType: CommandType.StoredProcedure);
    data = query.DapperParameters.Get<List<Dto>>("o_cur");
}