![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Fri, Apr 17 2009 10:45 AM | Permanent Link |
"James Relyea" | Will any errors encountered in a trigger be raised to the stored proc that
caused the trigger to fire? Then, can the stored proc raise the exception to the object that called the stored proc? Another DB does not raise trigger errors to anything & is an issue I discovered in another DB; I figured I'd ask before I discovered it myself. Thanks ![]() jr |
Fri, Apr 17 2009 1:11 PM | Permanent Link |
Fernando Dias ![]() | James,
> Will any errors encountered in a trigger be raised to the stored proc that > caused the trigger to fire? Then, can the stored proc raise the exception to > the object that called the stored proc? Yes. The stored procedure can raise or "eat" the exception. -- Fernando Dias [Team Elevate] |
Fri, Apr 17 2009 1:47 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | James,
<< Will any errors encountered in a trigger be raised to the stored proc that caused the trigger to fire? Then, can the stored proc raise the exception to the object that called the stored proc? >> Yes. In fact, unless you specifically catch them in a BEGIN..EXCEPTION block or an ON ERROR trigger, the exception will always be raised to the calling procedure and then on to the calling application. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |