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 do u mean by debit/credit memo invoices?

3 Answers   ACC, Convergys, Mascon,


Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  


Steps for DFF registration

2 Answers   IBM, Savvis, Wipro,


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

0 Answers  


what are the steps to develop a new report?

7 Answers   Infotech, Satyam,






Give a brief overview on OrderManagement.

1 Answers   Zensar,


while doing the process of conversion if got any data error out what is the next step to reprocess

1 Answers  


Is soa a part of oracle fusion middleware?

0 Answers  


difference between 2 way and 4 way matching

3 Answers   Convergys, TCS,


when will formula,place holder and summary columns fire in reports?

1 Answers   TCS,


What are the files we submit while your program move to testing instance?

4 Answers   Cap Gemini,


what are the difference between oracle discoverer and report6i

1 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)