Answer / amit

In a procedure, we can return a value using OUT PARAMETER
or EVEN USING IN OUT PARAMETER.

For Eg:

CREATE OR REPLACE PROCEDURE add_num(a IN NUMBER, b IN OUT
NUMBER) IS
BEGIN
b:= a + b;
END add_num;

The IN OUT / OUT parameters can be modified within PLSQL
block and the updated values of this parameter can be
refered using a actual paramter once the execution of this
procedure is completed.

Answer / ravindra babu kamma

using out parameter

Answer / veerabhargav reddy

In procedure we can return value using Out Parameter,

what is difference between po_headers_all and po_headers

2 Answers   NTT Data,

---

Is there any limitations on responsibility assigned to a apps user?

6 Answers   ESS,

---

What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.

2 Answers   IBM,

---

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,

---

How to generate XML Report with out using rdf?

6 Answers   BirlaSoft, Patni, UST,

---

What are the Major differences between appcore.pll and appcore2.pll

5 Answers   Infosys, Sierra Atlantica,

---

please explain open interface import

2 Answers  

---

What are profile options?

4 Answers   Accenture,

---

What is the Lookup's and what is the use of lookup's?

3 Answers   TCS,

---

Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,

---

hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me

2 Answers   Pathway Technologies,

---

in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,

---