PL/SQL “Do’s” 7 & 8
uUse WHEN OTHERS to save debugging time
ØHides errors and makes the code harder to debug.
ØCan save debugging time because it captures unpredictable events.
ØExplicitly placing exception handlers to cover all situations is impossible.
ØWHEN OTHERS allows you to intercept unspecified exceptions.
§Log an error message.
§Re-raise an exception in the exception block.
uUnderstand
when to pass parameters
or use global variables
ØIn a stateless, Web-based environment, cursors, functions, and procedures are sometimes unable to reference values outside of themselves.
§Instead,
they should pass parameters.
