cbaron wrote: > > On Apr 7, 10:49 pm, Michael Bayer <[email protected]> wrote: >> 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} > > Thanks Michael. I tried something like this, but I could not find any > generic or vendor specific type to specify for the cursor parameter > (e.g. something like .. outparam(':p_out', OracleCursor)). Does this > make sense?
im missing that part. the out parameter receives a cursor ? strange. you should at least modify your code to use cx_oracle's API, check out their site for information on that. I didn't realize a cursor was a datatype (seems very strange); --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. 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 -~----------~----~----~----~------~----~------~--~---
