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

Reply via email to