odbc: how to call a stored function in Oracle

Bill Tate 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;

Tom,
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 mailing list