|
|
Posted by Jeff Kish on 05/16/07 00:14
On Tue, 15 May 2007 21:37:39 +0000 (UTC), Erland Sommarskog
<esquel@sommarskog.se> wrote:
>Jeff Kish (jeff.kish@mro.com) writes:
>> I am trying to add some debug to a stored procedure.
>>
>> I put some statements like this throughout the code:
>>
>> select 'some message here';
>>
>> but I never see them.
>> I put them in a test procedure that works fine, so that I have a feeling
>> that when an insert fails in a down-stream try catch block, it messes up
>> the display of the information.
>>
>> Can someone tell me how to best go about outputting debug I can see from a
>> stored procedure, or if I am even correct about try catch blocks throwing
>> errors, messing up the debug visibility.
>
>I don't have any experience of the TRY-CATCH block messing up the output.
>If the debug SELECT does not appear, my interpretation is that the
>SELECT statement is never executed. That is, you never reach that part
>of the code.
>
>Seeing the actual code would make it easier to say what is going on.
thanks.
knowing nothing 'mysterious' is going on means I need to double check again
for ignorance on my part.
Jeff Kish
Navigation:
[Reply to this message]
|