[egenix-users] Passing a value from stored procedure to python?

[M.-A. Lemburg]

On 2007-01-22 02:13, Griff McClellan wrote:
> Hello,
> 
> I need to pass a value from a stored procedure or function to the calling 
> python script.  Nothing I have tried has worked.  I am using mx.ODBC.Windows 
> with Oracle 10g on Windows XP.
> 
> Can someone show me how a value, say 66, can be passed from a stored 
> procedure/function to a python variable?

You have to create a result using SELECT. mxODBC doesn't support
output parameters from stored procedures, but it does support
multiple result sets, so this is well possible, even if you have
more than one output parameter that you wrap into result sets.

Regards,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jan 22 2007)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::