DB API question - where is a stored procedure's return value?

Ian Kelly ian.g.kelly at gmail.com
Thu Mar 13 00:06:50 CET 2014


On Wed, Mar 12, 2014 at 5:00 PM, Ian Kelly <ian.g.kelly at gmail.com> wrote:
>     result = cursor.var(cx_Oracle.NUMBER)
>     cursor.execute(":1 := test_proc()", [result])
>     print(result.getvalue())

Sorry, that should properly be:

    result = cursor.var(cx_Oracle.NUMBER)
    cursor.execute("BEGIN :1 := test_proc(); END;", [result])
    print(result.getvalue())



More information about the Python-list mailing list