In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
Answer Posted / swati kapoor
User Defined exceptions are executed prior to system
defined exceptions.
User defined exceptions are executed in the order in which
they are defined.
When an exception is raised,normal execution of your PL/SQL
block or subprograms stops and control transfers to its
exception-handling part.
Note: When others should be handle in last of exception
handling part of block.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Explain what are the tables of auto invoice?
How do you register report in oracle apps?
Do you know what are user profiles in apps. Any examples you can give?
In support project one ticket alloted which steps follows manualy tell me ?
How is choreography different from orchestration?
In oracle application how do you debug or trace errors?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What are the different components you should consider while defining a responsibility in oracle apps?
Tell me how to debug the report?
Tell me how to find the custom directory in front end?
q)what are the validations in sql*loader
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
List the types of flexfield?
What do you understand by concurrent programs?
What is a value set? List its various types.