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;

If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?

4 Answers  

---

maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?

6 Answers   LG Soft,

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

0 Answers  

---

can we execute one concurrent program through another concurrent program?

1 Answers   KPIT,

---

what are the tables of auto invoice.

2 Answers  

---

Can We Create a Synonym On Trigger?

7 Answers   Exeter, Oracle,

---

Oracle E-Business suite?

2 Answers  

---

wht r the basetables of customer interface?

2 Answers  

---

1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function

2 Answers   Zensar,

---

tell me the scenarios of the independent in reports

0 Answers   Accenture, IBM,

---

what is the diff between custom.pll and form personalization? Tell me one example?

4 Answers   Oracle,

---

can we write sql statement in Format trigger?

4 Answers  

---