On Wednesday, October 3, 2012 1:58:11 AM UTC-7, Stu Gray wrote:
>
> For anyone interested, here is a basic approach:
>
> return_code = @db.synchronize do |conn|
> stmnt = conn.prepareCall('{ ? = call dbo.sp_sequel_test() }')
> stmnt.registerOutParameter(1, java::sql::Types::INTEGER)
> stmnt.execute
> # output parameters have not yet been processed, must call
> getMoreResults() first.
> stmnt.getMoreResults
> stmnt.getInt(1)
> end
>
Looks good, but you probably want to close stmnt after use, instead of
leaving that to the garbage collector.
If other people are interested in this, I'd be willing to accept a patch to
integrate such support into Sequel, though I'm not sure what the API would
look like.
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sequel-talk/-/R7-p6d1aG10J.
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/sequel-talk?hl=en.
