ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
   
 
Categories  >>  Software  >>  ERP CRM  >>  Oracle Apps  >>  Oracle Apps Technical
 
 


  

 
 Oracle Apps Technical interview questions  Oracle Apps Technical Interview Questions
 Oracle Apps Financial interview questions  Oracle Apps Financial Interview Questions
 Oracle Apps Manufacturing interview questions  Oracle Apps Manufacturing Interview Questions
 Oracle Apps HRMS interview questions  Oracle Apps HRMS Interview Questions
 Oracle Apps CRM interview questions  Oracle Apps CRM Interview Questions
 Oracle Apps SCM interview questions  Oracle Apps SCM Interview Questions
 Oracle Install Base interview questions  Oracle Install Base Interview Questions
 Oracle Service Contracts interview questions  Oracle Service Contracts Interview Questions
 Oracle Apps AllOther interview questions  Oracle Apps AllOther Interview Questions
Question 

How to pass data into EXECUTE_IMMEDIATE statement in plsql 
body ?
 Question Submitted By :: Sumeet.mishra05
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?
Answer
# 1		 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 ?    8 Yes 1 No
Eldho
 
  Re: How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?
Answer
# 2		 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 ?    2 Yes 1 No
M.n
 
 
 

 
 
 
Other Oracle Apps Technical Interview Questions
 
  Question Asked @ Answers
 
what is the difference between request group and request security in oracle apps?  1
what is Flex mode and Confine mode? Rapidigm2
what is instead of trigger in where u will use? TCS2
In Per_all_people_f table what is the significance of '_f ' ? HCL5
What is the difference between buyer&employee in PO module? TCS7
what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent . Oracle3
what are the receipt types in Po? UST2
How to create user and how u attach with responsibility. Accenture2
Please let me know the differance between Master Item and organization Item in Inventory. Wipro4
in reports token is casesensitive or not?  2
which is the table for storing organization information? Scan-Steel8
in one report using two layout models.if yes how to do Wipro2
 
For more Oracle Apps Technical Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com