How to pass data into EXECUTE_IMMEDIATE statement in plsql
body ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2221


Can we create tables in apps schema?

614


How can a process be deployed in soa?

692


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

1888


Tell me how to debug the report?

637






What is the concept of soa governance?

766


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2460


How to move the one file from one instance to another instance? And your scripts also?

615


Do you know what is applysys in oracle application database schema, what is apps?

673


how to print multi lay outs,muti currency,muti language in xml publisher

10721


Do you know where we can check the status of po?

636


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1799


What does appl_top directory contain?

645


Can u give the Documentation of Custom.pll in oracle apps

2993


please send me forms, xml pulisher questions,answers

1653