Interested to Buy Any Domain ? << Click Here >> for more details...
In Exception handling if we are using the when others first
then what happens . whether it will show the compiler error
- 2 Answers
- 12607 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subba
When Others exception needed to be handled last. If we use
When Others first, and then other exceptions, following
error will be prompted:
ORA-06550: line 8, column 3:
PLS-00370: OTHERS handler must be last among the exception
handlers of a block
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
| Is This Answer Correct ? | 38 Yes | 1 No |
Answer / uma
If we use when others first all the exceptions will be
caught by this block even when specific exception blocks
are present after that.Also no compiler error will be thrown
| Is This Answer Correct ? | 9 Yes | 16 No |
How to define default values for formal parameters?
How to change user password in oracle?
How to experiment a data lock in oracle?
How to login to the server without an instance?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
What is execute immediate in oracle?
How to Remove the 3rd highest salary person record from table?
What would you use to improve performance on an insert statement that places millions of rows into that table?
How to run the anonymous block again?
how do get database name at sql prompt?
How many categories of data types in oracle?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
Oracle General 
