In Exception handling if we are using the when others first
then what happens . whether it will show the compiler error
- 2 Answers
- 11979 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 would you do with an in-doubt distributed transaction?
where do i find oracle interview questions.
What do you mean by merge in oracle and how can we merge two tables?
How to define a variable to match a table column data type?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What happens if the imported table already exists?
What is oracle and what are its different editions?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
How to use subqueries with the exists operator in oracle?
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?
What are the limitations oracle database 10g xe?
Oracle General 
