:: 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                      
Categories >> Software >> ERP CRM >> Oracle Apps >> Oracle Apps Technical


 Oracle Apps Technical interview questions  Oracle Apps Technical Interview Questions (484)
 Oracle Apps Financial interview questions  Oracle Apps Financial Interview Questions (593)
 Oracle Apps Manufacturing interview questions  Oracle Apps Manufacturing Interview Questions (51)
 Oracle Apps HRMS interview questions  Oracle Apps HRMS Interview Questions (77)
 Oracle Apps CRM interview questions  Oracle Apps CRM Interview Questions (9)
 Oracle Apps SCM interview questions  Oracle Apps SCM Interview Questions (105)
 Oracle Install Base interview questions  Oracle Install Base Interview Questions (62)
 Oracle Service Contracts interview questions  Oracle Service Contracts Interview Questions (101)
 Oracle Apps AllOther interview questions  Oracle Apps AllOther Interview Questions (11)

How to pass data into EXECUTE_IMMEDIATE statement in plsql 
body ?
 Question Submitted By :: Oracle-Apps-Technical
I also faced this Question!!     Answer Posted By  
# 1
Hope this pice of code explains:

v_query VARCHAR2 (200);
v_employee_name VARCHAR2 (50);
v_query := 'SELECT emp_name from employees where emp_id =
INTO v_employee_name;
DBMS_OUTPUT.put_line ('Emp Name is ' || v_employee_name);
Is This Answer Correct ?    10 Yes 1 No
# 2
v_query VARCHAR2 (200);
v_inv_item_id VARCHAR2 (50);
v_query := 'SELECT inventory_item_id from
mtl_onhand_quantities_detail where inventory_item_id =107';
INTO v_inv_item_id;
DBMS_OUTPUT.put_line ('inventory_item_id ' ||
when others then
DBMS_OUTPUT.put_line ('inventory_item_id ' ||
Is This Answer Correct ?    4 Yes 1 No

Other Oracle Apps Technical Interview Questions
  Question Asked @ Answers
how to use .prt file in bitmap reports? Accenture 2
what is the diff between custom.pll and form personalization? Tell me one example? Oracle 4
where u do setup of operating unit? TCS 1
P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ? KPIT 9
which parameters passed in report in oracle developer how to pass   3
do i need to declare bind parameter before using in the query? Satyam 2
Can you have two functions with the same name in a pl/sql block? TCS 4
The report output is 10 pages then how many times between pages report trigger will fire? IBM 1
what are the prerequisite set ups for inter organization transaction? Scan-Steel 1
In interface how u find errors and how to solve. How to fix it?   3
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?   4
what is latest version in reports   8
For more Oracle Apps Technical Interview Questions Click Here 

Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
Copyright 2013  All Rights Reserved.   ::