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,

If there is any issue then whom do you report.(this is imp question for every interview)

3 Answers   Accenture,

---

In hierarchical structure of a database? we have write query from where we should start?

0 Answers   IBM,

---

How You Will display the key flexifields in your report

3 Answers   TCS,

---

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

0 Answers  

---

what are the tables of auto invoice.

2 Answers  

---

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

2 Answers   Pathway Technologies,

---

What is the difference between BPA AND Contract.

1 Answers   Accenture,

---

Attribute data types?

2 Answers  

---

what is the purpose of standard cost update?

2 Answers   Satyam, Scan Steel,

---

PL/SQL stored procedure parameters?

7 Answers  

---

Oracle E-Business suite?

2 Answers  

---

HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?

2 Answers   TCS,

---