Dapper Tutorial - Knowledge Base (KB)

Issue using Dapper with C# to call an Oracle stored proc with refcursor as out parameter, however refcursor as return value works

Given this oracle stored proc package:...CREATE OR REPLACE PACKAGE TESTPKG AS FUNCTION TestReturnRefCursor RETURN SYS_REFCURSOR; PROCEDURE TestingRefCursorsAsOutParam (outp OUT SYS_REFCURSOR); END TESTPKG ...And this package body:...CREATE OR REPLAC...

Dapper/Npgsql stored procedure with refcursor parameter query

I am using Dapper ( and I couldn't be happier), I know how to access normal stored procedures as mentioned ...here..., however, how do I pass on the the ...Npgsql...refcursor... name to the proc (using C#)? For example: ...I have a proc that looks like: ....