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
- 12601 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 |
Who developed oracle & when?
How to create additional tablespaces for an new database?
What are the various constraints used in oracle?
Can you assign multiple query result rows to a variable?
What happens to the data files if a tablespace is dropped?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
How do I spool to a csv formatted file using sqlplus?
Difference between NO DATA FOUND and %NOTFOUND?
What is backup in Oracle?
what is the exact diiference between DBMS and RDBMS
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
What are temporal data types in oracle?
Oracle General 
