That's using JDBC of course...
On Wednesday, 3 October 2012 09:58:11 UTC+1, 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
>
>
> On Wednesday, 3 October 2012 08:10:51 UTC+1, Stu Gray wrote:
>>
>> OK - thanks Jeremy.
>>
>> I'll look into Database#synchronize as you mention.
>>
>> Thanks again,
>> Stu
>>
>>
>> On Tuesday, 2 October 2012 18:20:03 UTC+1, Jeremy Evans wrote:
>>>
>>> On Tuesday, October 2, 2012 3:11:02 AM UTC-7, Stu Gray wrote:
>>>
>>>> Hi all,
>>>>
>>>> I asked this question on Stack Overflow yesterday, but maybe it's
>>>> better to come direct to you guys.
>>>>
>>>> In MS SQL Server a stored procedure can return an integer value called
>>>> a return
>>>> code<http://msdn.microsoft.com/en-us/library/ms190778%28v=sql.105%29.aspx>
>>>> to
>>>> indicate the execution status of a procedure.
>>>>
>>>> Does Sequel support this?
>>>>
>>>> The value returned from my_stored_proc.call() does not match the
>>>> integer I am returning in SQL. Is there some other way to access this?
>>>>
>>>> Thanks!
>>>>
>>>> Stu
>>>>
>>>>
>>>> http://stackoverflow.com/questions/12674874/stored-procedure-return-codes-in-sequel-ruby-orm
>>>>
>>>>
>>>>
>>> Unfortunately, Sequel's support for stored procedures is fairly limited.
>>> I don't believe it supports return codes or in/out variables. It's
>>> designed similarly to the prepared statement support, where delete/update
>>> returns the number of affected rows, and select yields rows.
>>>
>>> If Sequel's support doesn't meet your needs, use Database#synchronize to
>>> get to the underlying database connection, and operate directly on that
>>> using the connection's API (which depends on the driver in use).
>>>
>>> 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/-/zIkrhaoKwBoJ.
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.
