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

References	(1 earlier) <CALwzidm0GJ37JTjUUGPPgEXnZoh0ck08B7i2H4SZXXD1VyDcbA@mail.gmail.com> <mailman.8114.1394666303.18130.python-list@python.org> <lfsg5p$e1a$1@reader1.panix.com> <CAPTjJmqRgUGp=X5O_1pnJhK0=raZj7ALUg0DVsfhuCc0AcexuA@mail.gmail.com> <1394731328.29875.94134461.087FF85B@webmail.messagingengine.com>
Date	2014-03-14 04:32 +1100
Subject	Re: DB API question - where is a stored procedure's return value?
From	Chris Angelico <rosuav@gmail.com>
Newsgroups	comp.lang.python
Message-ID	<mailman.8132.1394731969.18130.python-list@python.org> (permalink)

Show all headers | View raw

On Fri, Mar 14, 2014 at 4:22 AM,  <random832@fastmail.us> wrote:
> DUAL is an Oracle thing. It used to have two rows, in order to be used
> to duplicate results by doing a cartesian join to it. At some point,
> that was removed, but the name stuck.
>
> Most other servers allow SELECT without FROM.

Yeah, I usually use PostgreSQL which does. I don't remember what DB2
has. MySQL I think requires either DUAL or an actual real table.

ChrisA

Back to comp.lang.python | Previous | Next — Previous 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