This is what I'm currently doing:
sql = '''BEGIN :result := cc_util.func(i_name => :name); END;'''
oramod = __engine__.engine.module
oracur = __engine__.engine.connection().connection.cursor()
result_var = oracur.var(oramod.NUMBER)
oracur.execute(sql, dict(name = name, result = result_var))
return result.getvalue()
Is there a better way? Maybe even a way to call a stored procedure automatically.
Tvrtko
- [Sqlalchemy-users] Binding output parameters Qvx 3000
- Re: [Sqlalchemy-users] Binding output parameters Michael Bayer