Re: [cx-oracle-users] How is cursor.callfunc() supposed to work?

[James C. M. <Jam...@or...>]

On 22/02/12 05:40 PM, Paul Moore wrote:
> On 22 February 2012 07:38, Paul Moore<p.f...@gm...>  wrote:
>>> So ... should I try to use cursor.callfunc() in the future,
>>> or just stick with statements like the above?
>>
>>  From this code, it appears the api call is a procedure, rather than a
>> function (no return value). The cursor.callfunc method won't work for
>> procedures, I suspect (no return type - you appear to have used
>> cx_Oracle.NUMBER in your tests, for some reason...). So I'd suggest
>> that you need to stick with the execute of a block solution.
>
> ... or use cursor.callproc, which I just noticed :-)

Hmmm. I thought it was declared as a function but on
re-reading the 1page snipped that is its documentation
I see in bold type "Procedure".

I think what had me confused is that the last 2 params
are modified by the routine and on error contain an
error code and a message.

Thanks for the tip, I'll see how it goes.

Cheers!

James C. McPherson
--
Oracle
http://www.jmcp.homeunix.com/blog