How To Retrieve Result Of Oracle Database Function Via Odbc?

I have problem with calling Oracle stored function (not procedure) via ODBC. My function is really simple, it just concatenates two strings. I can call it via: rs = c.execute('SELE

Solution 1:

Google brought up this page:

http://www.gossamer-threads.com/lists/python/python/71449

... I don't think ODBC supports stored procedures returning a value directly. Only as part of a cursor. ...

Basically, you can't call the function directly. You could, however, create a procedure with an OUT parameter instead.