What is the Exception.
Types of exception, Difference between those.
And example

Answers were Sorted based on User's Feedback



What is the Exception. Types of exception, Difference between those. And example..

Answer / hema

Exception is an error caused which leads to abnormal
termination of the program...
To handle these exceptions oracle provides 2 types of
exceptions.
1. oracle server exceptions
2. user-defined exceptions.

oracle server exceptions are the exceptions pre-defined by
the oracle server.
for example,
zero_divide with some error code. like -01400
array_out_of_bounds etc...

for all thse exceptions sqlcode is given(assigned by the
oracle sever)

there are pragma exceptions for which oracle has not given
the names.to assign the exception name with some oracle
defined code ...we go for pragma exceptions.

user-defined exceptions are those defined by the user.
for which the names as wel as code is given by the user.
there is some specified code range to assign to user-
defined exceptions.

Is This Answer Correct ?    14 Yes 5 No

What is the Exception. Types of exception, Difference between those. And example..

Answer / guest

Exception r unwanted situations which can occur in our
program , by handling them our code become robust.

There are 2 type of exception
1) User defined
2) default or system

Is This Answer Correct ?    9 Yes 4 No

Post New Answer

More Oracle Apps Technical Interview Questions

What is the Exception. Types of exception, Difference between those. And example

2 Answers   IBM,


What are basic steps for AIM?

2 Answers  


where the accounting related data is stored ?

2 Answers  


What is Value Set?

2 Answers   Accenture,


Cycle of requestion to receving transaction.

1 Answers   Accenture,


Is that Possible To create package without Specification , If Yes Give any Examples

2 Answers   PWC,


what is the error you will get if field is referenced in wrong repeating frame?

1 Answers  


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

0 Answers   Cap Gemini,


why do we validate the records while developing interface?

3 Answers   TCS,


what is global tempory table?

1 Answers   BirlaSoft,


Which module is not in multiorg

6 Answers   HCL, Wipro,


Give a overview on Aol

2 Answers   Zensar,


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)