In Exception handling if we are using the when others first
then what happens . whether it will show the compiler error
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 to commit the current transaction in oracle?
how may join possible between (requisition with purchase order)
What is the difference between $oracle_base and $oracle_home?
How to retrieve values from data fields in record variables?
What happens if you use a wrong connect identifier?
What are the limitations oracle database 10g xe?
Explain an integrity constrains?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is a select query statement in oracle?
Why oracle is used?
How to select some columns from a table in oracle?
Does facebook use oracle?
How to use values from other tables in update statements using oracle?
What are temporal data types in oracle?
How to grant create session privilege to a user in oracle?