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,629 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VB.Net - CSV to Oracle table 4 67
Oracle Listener Not Starting 11 44
Component is listed with a Protocol more than once 3 27
ODBC in excel 2016 in Windows 10 via VBA 16 60
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
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 videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to recover a database from a user managed backup

806 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