odbc: how to call a stored function in Oracle
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