In Exception handling if we are using the when others first
then what happens . whether it will show the compiler error
- 2 Answers
- 11995 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
What is the usage of merge statement?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
Explain the use of inctype option in exp command.
What are the different types of synonyms?
Explain the difference between replace() and translate() functions in oracle?
How can windows applications connect to oracle servers?
How to build data dictionary view an new database?
What is an oracle recycle bin?
How to assign data of the deleted row to variables?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to check your oracle database 10g xe installation?
Why do we use bulk collect in oracle?
what are the advantages of running a database in archive log mode?
Explain what are the type of synonyms?
What are the different types of database objects?
