How to pass data into EXECUTE_IMMEDIATE statement in plsql
body ?
Answer Posted / 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 View All Answers
what are the balancing segments in AR?
what is pay run id ?
Are you familiar with internet architecture of oracle apps 11i?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
What do you understand by concurrent programs?
how to print multi lay outs,muti currency,muti language in xml publisher
What is sca and how is it useful?
How many schemas we have? how many you have used?
Do you know what is applysys in oracle application database schema, what is apps?
What is instead of trigger in where we will use?
What are the different components of soa suite?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
What is a value set? List its various types.
Tell me how to debug the report?
what are the different transaction clauses in AR?