Hi Jeremy,
Thank you for your reply. I really appreciate the help that your team can
extend.
Maybe I didn't really explain in detail what I need. I would like to grab
the whole message returned when calling a stored procedure which shows up
in the Message Tab in T-SQL/SQL Server output which typically would log
something similar below:
*Msg 8134, Level 16, State 1, Line 56*
*Divide by zero error encountered.*
If I wanted to capture whatever message will be written, is there a method
from 'sequel gem' that I can use to grab the whole thing? Currently, I am
detecting the result set, if it contains return_code to be 0, then I
consider them as completed successfully. However, there are cases wherein,
it doesn't return an exception since the result set has return_code 0, but
there are error in the "messages" tab output.
Any advice on approaching this problem would be very much appreciated.
Regards,
elmer
On Friday, 1 June 2018 14:20:37 UTC+10, Jeremy Evans wrote:
>
> On Thursday, May 31, 2018 at 6:35:56 PM UTC-7, ELMER IBAYAN wrote:
>>
>> Hello sequel team,
>>
>> I am trying to capture error messages based on different scenarios when
>> calling stored procedures on T-SQL. I am able to grab result_set properly
>> when return_code 0 as the first row for normal successful case. However,
>> there are cases wherein, result set returns 0 return_code as well even if
>> it's a valid error. Since most of these valid errors have corresponding
>> error message, how can I grab these error_message using ruby?
>>
>> On another scenario where it raises an exception error, I can get the
>> "wrapped_exception.error_code". My second question is still how to get or
>> is there any method available to grab the rest of the message as a whole or
>> even by component such as "error_code" from wrapped_exception?
>>
>
> The wrapped_exception is generally the exception raised by the database
> driver. To get any lower level error handling, you would have to call
> methods on that object, and the methods supported are going to depend on
> the database driver in use. Refer to the database driver documentation
> and/or source code for which methods are available.
>
> Thanks,
> Jeremy
>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sequel-talk+unsubscr...@googlegroups.com.
To post to this group, send email to sequel-talk@googlegroups.com.
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.