On Exceptions and Rules

Wednesday Jul 9th 2008 by DatabaseJournal.com Staff
Share:

Best practices for where, when, and how to handle exceptions.

[From OTN]

I recently learned that if an exception is raised in the declaration section of my 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 my coding practices?

If an exception is raised in the declaration section of your block, that exception will propagate out of the block unhandled.

The article continues at http://www.oracle.com/technology/oramag/oracle/08-jul/o48plsql.html

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved