How to pass data into EXECUTE_IMMEDIATE statement in plsql
body ?

Answers were Sorted based on User's Feedback



How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?..

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;

Is This Answer Correct ?    11 Yes 1 No

How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?..

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;

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More Oracle Apps Technical Interview Questions

what is aim methodolozy

1 Answers  


Can u attach Request set with in the Request set?

2 Answers   Satyam,


How to call oracle database stored procedure from form in form coding ?

3 Answers   Oracle,


what is the difference between request group and request security in oracle apps?

1 Answers  


In support project one ticket alloted which steps follows manualy tell me ?

0 Answers   BEL, Questam,






tell my any difficult situtation you solved in your experience in your company?

0 Answers   Accenture,


We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,


In xml report, how to print the headings in every page?

1 Answers   Sierra Atlantica,


what is the database size you used?

1 Answers   FIS,


What are profile options?

4 Answers   Accenture,


You are working with interfaces if client doesnot give any flat then what will u do?

8 Answers   Wipro,


wht r the basetables of customer interface?

2 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)