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 the valueset if of type –TABLE then how many tables can we attach in the valueset ?

5 Answers   Wipro,

---

While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?

2 Answers  

---

What is secuirity's in R12 features.

1 Answers   KPIT,

---

In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?

2 Answers  

---

how to change the logo in template dynamically?

2 Answers   Sierra Atlantica,

---

any one can expalin report registration steps?

6 Answers   Infosys,

---

what do u mean by debit/credit memo invoices?

3 Answers   ACC, Convergys, Mascon,

---

what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions

1 Answers  

---

how can u link a org-id with a responsibility in reports?

2 Answers   TCS,

---

How do u customize the Reports?

1 Answers  

---

how can we return morethan one parameters in procedure?

2 Answers  

---

What is cursor?

3 Answers  

---