Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!nntp.club.cc.cmu.edu!micro-heart-of-gold.mit.edu!bloom-beacon.mit.edu!bloom-beacon.mit.edu!panix!gordon
From: John Gordon <gordon@panix.com>
Newsgroups: comp.lang.python
Subject: Re: DB API question - where is a stored procedure's return value?
Date: Thu, 13 Mar 2014 14:43:05 +0000 (UTC)
Organization: PANIX Public Access Internet and UNIX, NYC
Lines: 15
Message-ID: <lfsg5p$e1a$1@reader1.panix.com>
References: <CANc-5Uz98mTCjUuk_yOHqWeZRwp6JnTCagTQ=bzobhtWAceKxg@mail.gmail.com>  <CALwzidm0GJ37JTjUUGPPgEXnZoh0ck08B7i2H4SZXXD1VyDcbA@mail.gmail.com> <mailman.8114.1394666303.18130.python-list@python.org>
NNTP-Posting-Host: panix2.panix.com
X-Trace: reader1.panix.com 1394721785 14378 166.84.1.2 (13 Mar 2014 14:43:05 GMT)
X-Complaints-To: abuse@panix.com
NNTP-Posting-Date: Thu, 13 Mar 2014 14:43:05 +0000 (UTC)
User-Agent: nn/6.7.3
Xref: csiph.com comp.lang.python:68331

In <mailman.8114.1394666303.18130.python-list@python.org> Petite Abeille <petite.abeille@gmail.com> writes:


> Alternatively=85 if it=92s really a function=85 wrap it in a select =
> statement=85 such as:

> select foo() as value from dual

That will get the return value into an SQL variable, but the OP wanted
to know how to fetch it from python code.

-- 
John Gordon         Imagine what it must be like for a real medical doctor to
gordon@panix.com    watch 'House', or a real serial killer to watch 'Dexter'.