Re: [sqlalchemy] Oracle Function Out Params

2012-06-01 Thread Justin Valentini
Thanks Michael! On Thursday, May 31, 2012 3:31:13 PM UTC-4, Michael Bayer wrote: There's an outparam() construct specifically for Oracle OUT parameters. Here's an example: from sqlalchemy import text, bindparam, outparam result = \ db.execute(text('begin

[sqlalchemy] Oracle Function Out Params

2012-05-31 Thread Justin Valentini
I'm having difficulty determining how to correctly call an oracle package function which returns a numeric value. I want to call this: BEGIN :out := my_schema.my_package.test_function(); END; I tried calling that using sqlalchemy.text() but I don't understand how to tell the procedure I want

Re: [sqlalchemy] Oracle Function Out Params

2012-05-31 Thread Michael Bayer
There's an outparam() construct specifically for Oracle OUT parameters. Here's an example: from sqlalchemy import text, bindparam, outparam result = \ db.execute(text('begin foo(:x_in, :x_out, :y_out, ' ':z_out); end;',