The SUPPRESSES_WARNING_6009 pragma allows more robust error handling and better encapsulation and modularization.

The PL/SQL compiler issues warning PLW-06009 if it determines that an OTHERS exception handler does not, in all cases, end in either an explicit RAISE statement or in a call to the PL/SQL supplied procedure RAISE_APPLICATION_ERROR. The compiler's behavior is too aggressive for some programming styles when programmers supply their own reporting subroutines. This new pragma quiets the warning.

Related Topics