In Exception handling if we are using the when others first
then what happens . whether it will show the compiler error
- 2 Answers
- 11510 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 a materialised view?
What is a trigger and what are its types?
What are the data types in oracle?
what is load balancing and what u have used to do this?(sql loader)
What is the difference between "as" and "is" in an oracle stored procedure?
How do I know if oracle client is installed on windows?
How to write a query with an inner join in oracle?
What is the maximum limit on the number of columns in a table?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
What is materialized view in Oracle?
How do we switch from init.ora file to asp file?
Oracle General 
