How many parameters we can pass through pl/sql program in
Oracle apps

Answers were Sorted based on User's Feedback



How many parameters we can pass through pl/sql program in Oracle apps..

Answer / indra sena reddy

question was not clear are you asking mandatory out
parameters or what??
the mandatory outparameters are 2( retcode and errbuf)
or we can pass any number of in parameters

Is This Answer Correct ?    6 Yes 2 No

How many parameters we can pass through pl/sql program in Oracle apps..

Answer / akshay

100 parameter will be for concurrent program not including
the errbuf and return code.

Is This Answer Correct ?    2 Yes 0 No

How many parameters we can pass through pl/sql program in Oracle apps..

Answer / pradeep

 we can pass 100 parameter for concurrent program by using Fnd_request.submit_request, here 2 parameters are mandatoryi.e, 
1) errbuf  2)retcode

Is This Answer Correct ?    0 Yes 0 No

How many parameters we can pass through pl/sql program in Oracle apps..

Answer / muneer

S QUS IS NOT CLEAR ANY WAY IF THE PLSQL BLOCK IS PROCEDURE
THEN WE CAN PASS 100 PARAMETERS INCLUDING ERRBUF AND RETCODE

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More Oracle Apps Technical Interview Questions

Can anybody tell me, What is the Implementation Process?

2 Answers   TCS,


1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

2 Answers   Cap Gemini,


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

0 Answers  


Which module is not in multiorg

6 Answers   HCL, Wipro,


what is back order in OM

4 Answers   IBM, Oracle,






what is pick selection list generation report.

3 Answers  


Can u define DFF with in the DFF,How?

1 Answers   Satyam,


In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,


about TCA architecture

1 Answers   TCS,


what is aim methodolozy

1 Answers   Wipro,


Do you know what is applysys in oracle application database schema, what is apps?

0 Answers  


is it possible to run the interface without using oracle apps?

2 Answers   Accenture,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)