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
Can multiple columns be used in group by in oracle?
How to insert a record into a table?
How to retrieve data from an cursor to a record?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What do you mean by a tablespace?
How to define an external table with a text file?
What is a sub query? What are its various types?
What is control file used for?
What are the predefined tablespaces in a database?
What is background process in Oracle?
How to convert characters to numbers in oracle?
How to define an explicit cursor in oracle?
How do I connect to oracle database?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is the usage of analyze command in oracle?