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
- 12474 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 max number of columns in an oracle table?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
query to find the maximum no persons with same age(age colomn) from emp table
How can we find out the current date and time in oracle?
what is the syntax of CREATE command?
What is a synonym? What are its various types?
How many memory layers are in the shared pool?
which statement is running fastly ie insert or delete?
how to genarate random numbers in oracle for particular row?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
What is translate in oracle?
What is a proxy object?
Oracle General 
