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
- 12600 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 to define an anonymous procedure without variables?
How much memory your 10g xe server is using?
How to convert character types to numeric types?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
what is the difference between substr and instr function in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Can we create database in oracle using command line ?
How to create a testing table in oracle?
How to see free space of each tablespace?
What happens if you use a wrong connect identifier?
How to recover a dropped table in oracle?
how to make an oracle object
What is a nested table?
Can group functions be mixed with non-group selection fields?
