Oracle not binding output parameters

ServiceStack.OrmLite Oracle
1

Hi all,

I am attempting to execute an oracle stored procedure. When I have no output parameters, the code works fine. However, when I add in an output parameter, I get the oracle error, not all parameters are bound. Here is a simplified version of my code and sproc.

Here is the stored procedure

CREATE OR REPLACE PROCEDURE TEST 
(
  PARAM1 IN VARCHAR2 
, PARAM2 OUT VARCHAR2 
) AS 
BEGIN
  NULL;
END TEST;

Here is the code.

    using (var cmd = Db.SqlProc("test", new { PARAM1 = "bob" }))
    {

        cmd.AddParam("PARAM2", direction: ParameterDirection.Output);

        cmd.ExecNonQuery();
    }

I can revert to using the regular old fashioned oracle client to do this, but I really want to use the power or ormlite for this. Any suggestions or something glaringly wrong with the way I am trying to accomplish this?

2

That’s normally how you’d create a query with out parameters, but it mustn’t be supported in Oracle.

Note: We don’t support for Oracle ourselves or have an instance to be able to test against but you may be able to use the embedded version of Dapper in OrmLite to access the out parameter.