odbc: how to call a stored function in Oracle

Tim Roberts timr at probo.com
Thu Nov 8 06:36:27 CET 2001


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;

--
- Tim Roberts, timr at probo.com
  Providenza & Boekelheide, Inc.



More information about the Python-list mailing list