In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
- 1 Answers
- 8102 Views
- Oracle, I also Faced
- E-Mail Answers
Answer / 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 |
What is workflow?Explain with a example?
what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?
What are the User PARAMETERS in the Reports?
how to make a parameter optional in the query?
can we pass bind variablein lexical parameter?
After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?
How you will Diaplay the Company LOGO In report.Can anyone knows please give solution
where the accounting related data is stored ?
what are the functions you are used in utl_file at the time of transferring the data?
what is the use of placeholer column?
What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1
how to create requst set in oracle apps and how to send muliple requests at a time,
Oracle Apps Technical 
