In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?



In a package have predefined exception and user defined exception. while execution which exception w..

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

Post New Answer

More Oracle Apps Technical Interview Questions

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

0 Answers  


How to call oracle database stored procedure from form in form coding ?

3 Answers   Oracle,


What is multoorg and what is it's level or structure

4 Answers   IBM,


Stored procedure?

4 Answers  


In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?

2 Answers  


in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?

1 Answers   Oracle,


can we get profile values in report without using user exists is it possible how?

0 Answers   Cap Gemini,


what are the tables of auto invoice.

2 Answers  


what is the difference between credit memo and debit memo?...

2 Answers   Sony,


1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function

2 Answers   Zensar,


In hierarchical structure of a database? we have write query from where we should start?

0 Answers   IBM,


List the various types of value set.

0 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)