Programming Languages White Papers
On Ignoring, Locking, and Parsing
Overview There's a programming construct, WHEN OTHERS, in PL/SQL that the author wishes weren't there. This clause, when used in an exception block, catches any unhandled exceptions. There are times when this is useful, such as for logging errors. But the problem the author sees is that far too many people use the WHEN OTHERS clause without following it by a RAISE or RAISE_APPLICATION_ERROR call. That effectively hides the error. In reality, the error happened, but it was not handled in any meaningful way; it was just ignored - silently. The invoker of one's code has no idea that something went horribly wrong and that the code failed, and he or she typically thinks that everything was, in fact, successful.
| Publisher | Oracle | File Format | HTML |
|---|---|---|---|
| Date Published | July 2007 | Downloads | 4 |
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful? 6 out of 8 users found this white paper useful
White Paper RSS
Download
Register
