[erlang-questions] ODBC parametrized query and out parameter

Tomasz Maciejewski <>
Wed Jan 11 15:08:31 CET 2012


Hello everyone!

I've got a PL/SQL function in an Oracle database which returns values
through out parameter. How can I call it and receive with
odbc:param_query/3? I've tried something like this:

   odbc:param_query(Ref, "CALL FOOBAR(?, ?)", [{{sql_varchar, 20}, in,
["foo"]}, {{sql_varchar, 20}, out, Result}])

but I got:

exception exit: {badarg,odbc,param_query,'Params'}
     in function  odbc:decode/1

I can't see anything about procedures and function (or out parameters)
in the documentation.

-- 
Tomasz Maciejewski



More information about the erlang-questions mailing list