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
In support project one ticket alloted which steps follows manualy tell me ?
Can we create tables in apps schema?
How can a process be deployed in soa?
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
Tell me how to debug the report?
What is the concept of soa governance?
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.
How to move the one file from one instance to another instance? And your scripts also?
Do you know what is applysys in oracle application database schema, what is apps?
how to print multi lay outs,muti currency,muti language in xml publisher
Do you know where we can check the status of po?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What does appl_top directory contain?
Can u give the Documentation of Custom.pll in oracle apps
please send me forms, xml pulisher questions,answers