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
What is a database schema in oracle?
What are the ansi data types supported in oracle?
What is flashback in Oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is the difference between truncate & delete command?
How to call a stored function in oracle?
What is Redo Log Buffer in Oracle?
How to delete all rows a table in oracle?
How to shutdown your 10g xe server?
How to define default values for formal parameters?
What is save point in oracle database?
What is the difference between view and materialized view in Oracle?
What is logical backup in oracle?
How to divide query output into groups in oracle?
What is an oracle wallet?