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 are the difference between 11.5.7 and 11.5.9 in oracle apps

4 Answers  

---

How You Will display the key flexifields in your report

3 Answers   TCS,

---

Define MultiOrg Structure

5 Answers   Convergys,

---

In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  

---

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,

---

---

What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,

---

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

0 Answers  

---

what is instead of trigger in where u will use?

2 Answers   TCS,

---

How to create a link between One dependent value set to another Dependent value set

5 Answers   Indorama, ManSoft System, Syntel, TE Data,

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

0 Answers  

---

What are ad-hoc reports?

1 Answers  

---