Answer / eldho

Hope this pice of code explains:

declare
v_query VARCHAR2 (200);
v_employee_name VARCHAR2 (50);
BEGIN
v_query := 'SELECT emp_name from employees where emp_id =
102';
EXECUTE IMMEDIATE v_query
INTO v_employee_name;
DBMS_OUTPUT.put_line ('Emp Name is ' || v_employee_name);
END;

Answer / m.n

declare
v_query VARCHAR2 (200);
v_inv_item_id VARCHAR2 (50);
BEGIN
v_query := 'SELECT inventory_item_id from
mtl_onhand_quantities_detail where inventory_item_id =107';
EXECUTE IMMEDIATE v_query
INTO v_inv_item_id;
DBMS_OUTPUT.put_line ('inventory_item_id ' ||
v_inv_item_id);
exception
when others then
DBMS_OUTPUT.put_line ('inventory_item_id ' ||
v_inv_item_id);
END;

while running a interface if we get 100 records as erors. how to debug it.

2 Answers   Zensar,

---

Tell me some thing about SQL-LOADER.

2 Answers   IBM,

---

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

2 Answers   Sierra Atlantica,

---

what is the standard program for blanket po to process data from interface table to bace table

3 Answers   Zensar,

---

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

4 Answers   Infosys, Sierra Atlantica,

---

---

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

3 Answers  

---

what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,

---

How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?

2 Answers   Oracle,

---

how to change the logo in template dynamically?

2 Answers   Sierra Atlantica,

---

Cycle of requestion to receving transaction.

1 Answers   Accenture,

---

How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?

1 Answers  

---

What is SET-OF-BOOKS?

3 Answers  

---