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

References	<CANc-5Uz98mTCjUuk_yOHqWeZRwp6JnTCagTQ=bzobhtWAceKxg@mail.gmail.com> <CALwzidm0GJ37JTjUUGPPgEXnZoh0ck08B7i2H4SZXXD1VyDcbA@mail.gmail.com>
From	Ian Kelly <ian.g.kelly@gmail.com>
Date	2014-03-12 17:06 -0600
Subject	Re: DB API question - where is a stored procedure's return value?
Newsgroups	comp.lang.python
Message-ID	<mailman.8112.1394665660.18130.python-list@python.org> (permalink)

Show all headers | View raw

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())

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

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

csiph-web