Interested to Buy Any Domain ? << Click Here >> for more details...
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
- 1 Answers
- 7978 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 |
How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?
What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.
How to migrate .rdf file from dev instance to test instance?
3 Answers Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,
Cycle of requestion to receving transaction.
What is FORWARD DECLARATION in Packages?
6 Answers British Telecom BT, HCL, Tech Mahindra,
Difference between set of books id and ledger id in r12 ?
Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?
what is repeting frame?
how can u link a org-id with a responsibility in reports?
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
What are do's and dont's of Interface?
what are the different transaction clauses in AR?
Oracle Apps Technical 
