Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


maximum how many parameters we can pass through pl/sql
stored procedure to oracle apps?how many mandatory
parameters we can pass through pl/sql program to oracle
apps11i?

Answers were Sorted based on User's Feedback



maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many ma..

Answer / raj

100 paramters can be passed using FND_REQUEST.SUBMIT_REQUEST

errorbuf and retcode should always be passed while creating
pl/sql stored procedure for oracle apps.

Is This Answer Correct ?    34 Yes 4 No

maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many ma..

Answer / bobbyiiit

100 parameteres is the limit while a pl/sql is used in Apps.

2 parameters are mandatory
1-> ErrBuf
2-> Retcode

Is This Answer Correct ?    23 Yes 1 No

maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many ma..

Answer / muneer

WE CAN PASS 100 PARAMETERS INCLUDING ERRBUF AND RETCODE

Is This Answer Correct ?    11 Yes 1 No

maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many ma..

Answer / anand

For SQL Stored Procedure we can pass upto 2100 Parameters.

Is This Answer Correct ?    7 Yes 10 No

maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many ma..

Answer / hamza zaheer

we can pass unlimited parameters in a function...

Is This Answer Correct ?    2 Yes 8 No

maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many ma..

Answer / rasa

1024 Parameters a Sql Server SP can support

Is This Answer Correct ?    6 Yes 14 No

Post New Answer



More Oracle Apps Technical Interview Questions

How to know the number of invoices generated for one PO from front end (navigation)?

1 Answers   Oracle,


what is the difference between oracle 8i and 9i?

1 Answers  


What is procedure?

3 Answers   IBM,


what are the prerequisite set ups for inter organization transaction?

1 Answers   Scan Steel,


in ap_terms table what data will be stored

2 Answers   Wipro,






why r u move in the cus_top only why not move another top

4 Answers   Wipro,


How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?

1 Answers  


how to initialize applications?

2 Answers  


How do u customize the Reports?

1 Answers  


How to generate XML Report with out using rdf?

6 Answers   BirlaSoft, Patni, UST,


What is cursor?

3 Answers  


What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (791)
  • 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)