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
- 12452 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 |
State the difference between a primary key and foreign key?
What are the different types of record groups in oracle? Explain each of them
Why does for update in oracle 8 cause an ora-01002 error?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
What is hash cluster in oracle?
What is analyze command used for?
What are the advantages of oracle 12c?
Is insert autocommit in oracle?
What is the difference between 10g OEM and 11g OEM?
Which is better Oracle or MS SQL? Why?
How to concatenate two text values in oracle?
Oracle General 
