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
- 12684 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 |
What is the difference between I and G in Oracle?
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?
What are the execution control statements?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
difference between truncate and delete ,drop?
What are ddl statements in oracle?
What is program global area (pga) in oracle?
How to find no of saturdays in a month using single sql ?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How do you tell what your machine name is and what is its IP address?
Oracle General 
