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 the Exception. Types of exception, Difference between those. And example

2 Answers   IBM,

---

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

2 Answers   Pathway Technologies,

---

FLEX FIELDS?

2 Answers  

---

List the types of flexfield?

0 Answers  

---

Where I can download D2K software?

2 Answers  

---

what is difference between API and Interface?

2 Answers   Infogain,

---

wht is format triger?

4 Answers  

---

Tell me some thing about SQL-LOADER.

2 Answers   IBM,

---

How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/

4 Answers   Satyam,

---

where u do setup of operating unit?

1 Answers   TCS,

---

what are the different types of triggers in reports

2 Answers   Oracle,

---

What do you understand by soa and what are the benefits of using this architecture?

0 Answers  

---