On Exceptions and Rules: Best Practices for Where, When, and How to Handle Exceptions
Source: Oracle
If an exception is raised in the declaration section of one's block, that block's exception section cannot handle the exception. That doesn't seem right. Why does PL/SQL work this way, and what does it mean for the author's coding practices? If an exception is raised in the declaration section of one's block, that exception will propagate out of the block unhandled. PL/SQL behaves like this (or, to be more accurate, the Oracle PL/SQL development team decided to implement exception handling like this) because until local variables and constants are fully elaborated, one doesn't have a viable subprogram with which to work. Suppose the declaration-raised exception were handled inside that subprogram. To what could one refer inside the exception handler?
| Format: | HTML | Size: | 0.00 |
| Date: | Jul 2008 |
People who downloaded this item also downloaded
- Mastering Oracle+Python, Part 5: Stored Procedures, Programming Python
- MSDN Architecture Webcast: Patterns & Practices Live!: Pattern Based Development Using the .NET Framework (Level 100)
- MSDN Architecture Webcast: Patterns & Practices Live - Enterprise Library Exception Handling Application Block (Level 300)
- Taking Advantage of Microsoft Enterprise Library 4.0 for Visual Studio 2008
- Exception-Chain Analysis: Revealing Exception Handling Architecture in Java Server Applications



