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,499 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
Comment Utility
[modder]
0
 
LVL 2

Expert Comment

by:RMZ
Comment Utility
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
Comment Utility
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now