Subject | SUSPEND - Was: problem with very simple Stored Procedure |
---|---|
Author | Artur Anjos |
Post date | 2002-08-27T13:06:17Z |
Hi
understand why we must use the suspend if the SP is called by EXECUTE, not
by SELECT.
For now, I'm using SUSPEND when I need to, and never use it when I use
EXECUTE to run the SP. Just like in the documentation :-). No problems at
all.
Is there any logical explanation about this so aready discussed subject? I
have seen so many posts about it, but no conclusion at all.
Artur
> you should always have the suspend; (...)I have seen over the times a lot of discussion about this. Really, I don't
understand why we must use the suspend if the SP is called by EXECUTE, not
by SELECT.
For now, I'm using SUSPEND when I need to, and never use it when I use
EXECUTE to run the SP. Just like in the documentation :-). No problems at
all.
Is there any logical explanation about this so aready discussed subject? I
have seen so many posts about it, but no conclusion at all.
Artur