DB API question - where is a stored procedure's return value?
Ian Kelly
ian.g.kelly at gmail.com
Wed Mar 12 19:06:50 EDT 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