Re: [sqlalchemy] Oracle Function Out Params
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 foo(:x_in, :x_out, :y_out, ' ':z_out); end;', bindparams=[bindparam('x_in', Float), outparam('x_out', Integer), outparam('y_out', Float), outparam('z_out', String)]), x_in=5) print result.out_parameters On May 31, 2012, at 12:17 PM, Justin Valentini wrote: 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 to use an out parameter. I also tried using the func module but couldn't get that to work either. Can someone point me to an example of the correct syntax? -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/-TPZ33REargJ. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/31S_fWPbCe4J. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
[sqlalchemy] Oracle Function Out Params
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 to use an out parameter. I also tried using the func module but couldn't get that to work either. Can someone point me to an example of the correct syntax? -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/-TPZ33REargJ. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
Re: [sqlalchemy] Oracle Function Out Params
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;', bindparams=[bindparam('x_in', Float), outparam('x_out', Integer), outparam('y_out', Float), outparam('z_out', String)]), x_in=5) print result.out_parameters On May 31, 2012, at 12:17 PM, Justin Valentini wrote: 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 to use an out parameter. I also tried using the func module but couldn't get that to work either. Can someone point me to an example of the correct syntax? -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/-TPZ33REargJ. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.