Solved

Why is it good practice to place an 'others' exception handler in the outermost block of a PL/SQL program unit?

Posted on 2001-07-17
3
3,701 Views
Last Modified: 2011-10-03
Why is it good practice to place an 'others' exception handler in the outermost block of a PL/SQL program unit?  
Choice 1  
 This method provides a handler to which any exceptions not handled by specific exception handlers will be propagated.  
Choice 2  
 'others' is the most inefficient exception handler and it should be placed as a last resort after all other exceptions have been handled.  
Choice 3  
 Exception handling is a bad practice in general and should be avoided.  
Choice 4  
 'others' exception handlers should be used sparingly because their definition provides the least possible information about the exceptions they trap.  
Choice 5  
 If 'others' is placed before explicitly-stated exception handlers, it will catch all exceptions and over-ride the ability of the explicit handlers to execute.  
0
Comment
Question by:Daman
3 Comments
 

Accepted Solution

by:
Kirilloff earned 0 total points
ID: 6289888
[modder]
0
 
LVL 2

Expert Comment

by:RMZ
ID: 6289890
This method provides a handler to which any exceptions not handled by specific exception handlers will
be propagated.  
0
 
LVL 3

Expert Comment

by:modder
ID: 6293009
Hello Daman

I would like to point you to the member agreement. You can find a link to that on the bottom of every page.

Specifically the Guidelines for use, in which it states that Experts Exchange shall not be used for

* violating the guidelines for academic honesty or other unethical behavior.

In other words:

Experts-Exchange is not a homework service. Please stop using it for this purpose.

Kirilloff, I've reduced the points to zero.

modder
Community Support Moderator@Experts-Exchange
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question