[cx-oracle-users] Oracle functions and input/output parameters

[Nik B. <Nik...@pe...>]

Hi,

I have an Oracle function that has an output parameter, e.g.

 GetStuff(number1, number2, outstring)

where outstring is a VARCHAR2. The funtion returns an error code, or 0 for
success in which case the data is in outstring.

When calling this via cx_Oracle's callfunc(), I get the return code but no
data in outstring. Looking at the docs I suspect this is expected behaviour;
previously I've only dealt with input/output parameters with callproc()
which works fine.

Should callfunc() be populating outstring or do I need to get our Oracle
guys to rewrite the functions as procedures and use callproc()?

Many thanks,

Nik