What is the Exception.
Types of exception, Difference between those.
And example
Answer Posted / 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 |
Post New Answer View All Answers
Are you familiar with internet architecture of oracle apps 11i?
what are the balancing segments in AR?
What are the Standard Reports and Forms in HRMS?
What are the benefits of using soa architecture?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Which oracle apps version you are very confident in?
What are the different components of soa suite?
How many schemas we have? how many you have used?
What is a flexfield? List out its types.
testing tools?
In sequence i want to 11 and 15th values how we will write?
what is the differences between internal requisition and internal sales order?
Tell me where we find the status of order information?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
What are do's and dont's of Interface?