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
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
do you know is it possible to run the interface without using oracle apps?
what is the differences between internal requisition and internal sales order?
Is soa a part of oracle fusion middleware?
What do you understand by soa and what are the benefits of using this architecture?
how can i print random rows in plsql table
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
what are the balancing segments in AR?
what are the prerequisites for costing transactions?
What do you understand by concurrent programs?
In hierarchical structure of a database? we have write query from where we should start?
How can we import the data into a database using sql * loader?
tell my any difficult situtation you solved in your experience in your company?
Do you know what are user profiles in apps. Any examples you can give?
List the various types of value set.