Dapper Tutorial - Knowledge Base (KB)

Why using Dapper I get an issue with Oracle stored procedure with refcusors as out parameter?

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...

How in Dapper I pass argument to a select query in an Oracle database?

I'm trying to pass parameters to Dapper for a select query in an Oracle database, but somehow, it doesn't work with the ":" identifier....It works fine using string concatenation :...string req = "SELECT * FROM contact WHERE code_comite = '"; req ...

How can I retrieve the last identity value inserted with Dapper?

I'm querying DB Oracle and would like to return the entered id. I use a sequence that automatically generates the next id for me. I've already tried this, but I have an "ORA-00933 sql command terminated incorrectly" exception. What is the error? Thank you...