On Apr 7, 2009, at 4:11 PM, cbaron wrote:
>
> Hey all,
>
> I have to call some pre-existing Oracle stored procedures that have
> cursor out parameters. I've had no luck doing this short of using
> "raw" cursors. Is there a better way to do this?
we have an outparam construct which makes use of cx_oracle's built in
API for this:
result = testing.db.execute(text("begin
foo(:x_in, :x_out, :y_out, :z_out); end;",
bindparams=[bindparam('x_in', Numeric), outparam('x_out', Numeric),
outparam('y_out',
Numeric), outparam('z_out', String)]), x_in=5)
assert result.out_parameters == {'x_out':10, 'y_out':75, 'z_out':None}
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
