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

Subject	Re: DB API question - where is a stored procedure's return value?
From	Petite Abeille <petite.abeille@gmail.com>
Date	2014-03-13 00:11 +0100
References	<CANc-5Uz98mTCjUuk_yOHqWeZRwp6JnTCagTQ=bzobhtWAceKxg@mail.gmail.com> <CALwzidm0GJ37JTjUUGPPgEXnZoh0ck08B7i2H4SZXXD1VyDcbA@mail.gmail.com>
Newsgroups	comp.lang.python
Message-ID	<mailman.8114.1394666303.18130.python-list@python.org> (permalink)

Show all headers | View raw

On Mar 13, 2014, at 12:00 AM, Ian Kelly <ian.g.kelly@gmail.com> wrote:

> As a general solution, one might wrap a stored procedure that returns
> a value into a stored procedure that has an output parameter and call
> it with callproc.  Some implementations might include a return value
> in the parameter list anyway.

Alternatively… if it’s really a function… wrap it in a select statement… such as:

select foo() as value from dual

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

Thread

Re: DB API question - where is a stored procedure's return value? Petite Abeille <petite.abeille@gmail.com> - 2014-03-13 00:11 +0100
  Re: DB API question - where is a stored procedure's return value? John Gordon <gordon@panix.com> - 2014-03-13 14:43 +0000
    Re: DB API question - where is a stored procedure's return value? Skip Montanaro <skip@pobox.com> - 2014-03-13 10:14 -0500
    Re: DB API question - where is a stored procedure's return value? Chris Angelico <rosuav@gmail.com> - 2014-03-14 04:01 +1100
    Re: DB API question - where is a stored procedure's return value? random832@fastmail.us - 2014-03-13 13:22 -0400
    Re: DB API question - where is a stored procedure's return value? Chris Angelico <rosuav@gmail.com> - 2014-03-14 04:32 +1100

csiph-web