Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #68307 > unrolled thread

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

Back to article view | Back to comp.lang.python

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: DB API question - where is a stored procedure's return value? Ian Kelly <ian.g.kelly@gmail.com> - 2014-03-12 17:06 -0600

#68307 — Re: DB API question - where is a stored procedure's return value?

On Wed, Mar 12, 2014 at 5:00 PM, Ian Kelly <ian.g.kelly@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())

[toc] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web