odbc: how to call a stored function in Oracle
tatebll at aol.com
Thu Nov 8 14:42:06 CET 2001
Tim Roberts <timr at probo.com> wrote in message news:<j66kutg7m8s1q311igl6jmndtgdjkgu2jm at 4ax.com>...
> tom.hines at usa.net (Tom Hines) wrote:
> >Hi. I'm using ActivePython 2.1.212 and MS ODBC driver for Oracle. I
> >am able to call a stored procedure that returns a cursor, but I
> >haven't been able to figure out how to call a stored function or a
> >procedure that has an output parameter.
> I don't think ODBC supports stored procedures returning a value directly.
> Only as part of a cursor.
> I also don't know Oracle; it is possible for you to restate that as a
> SELECT statement with a constant, one-row result, as in:
> SELECT Call MYPKG.MYFUNC (?) AS result;
I've run into the identical problem in the past. DCOracle is
frequently used to accessing stored procedures in Oracle using ZOPE -
while I've never used it for this particular problem, it appears to
support essentially what amounts to a function call. Someone else
perhaps can speak to this directly. In any event, suggest checking
out http://www.zope.org/Products/DCOracle/DCOracle.txt -
Now if there one for postgre as well - time for google.
More information about the Python-list