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
- 12453 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How will you differentiate between varchar & varchar2?
How to use fetch statement in a loop?
How to create a stored function in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
Difference between varchar and varchar2 data types?
What are the database administrators utilities available?
what is the difference between restoring and recovering?
Explain the use of online redo log files in oracle.
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Explain what are clusters?
What is an index associated with a constraint?
Give the different types of rollback segments.
What is tns entry?
How to create a table index?
Explain the difference between replace() and translate() functions in oracle?
