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,

Can you have two stored functions with in the same name?

3 Answers  

---

What repots or concurrent program run to transfer data from Inventory to GL.

5 Answers   IBM, iGate,

---

While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions

3 Answers   IBM,

---

1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

2 Answers   Cap Gemini,

---

Which is the best website to learn Oracle Apps?

2 Answers  

---

how to enable Zoom function and steps?

1 Answers   Patni,

---

Which one Module is Biggest Module in oracle apps?

3 Answers   Questam,

---

In report we have to show two Layout? how it is and how we can see from where it?

3 Answers   IBM,

---

i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,

---

Can you define an erp system?

0 Answers  

---

whats the use of after parameter form and before report?

2 Answers   IBM,

---

what is the need of registering table in apps?

5 Answers   TCS,

---