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 [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> 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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
