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.

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 it possible to do purchase order without requisition?

8 Answers  

---

Which is the best website to learn Oracle Apps?

2 Answers  

---

what is difference between procedure and function

5 Answers   E Logic,

---

testing tools?

0 Answers   BirlaSoft, Convergys,

---

what is difference between d2k report and oracle apps report

10 Answers   Seven Hills, Wipro,

---

There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

3 Answers   Satyam,

---

How relation will be made between modules in oracle financial?

4 Answers   HCL, Wipro,

---

What are ad-hoc reports?

1 Answers  

---

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,

---

what is meant by boilerplates?

1 Answers  

---

What is responsibility and how u attach

5 Answers   Accenture,

---

in which table sub inventory related information for item is stored?

3 Answers   chain sys, Scan Steel,

---