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

in ap_terms table what data will be stored

2 Answers   Wipro,


where is chandra institute in hyderabad for oracle apps technical training ?

2 Answers  


can we use look up type instead of a pofile option?or valueset?is it possible how?

0 Answers   Cap Gemini,


What is request group

4 Answers   Accenture,


what is lexical parameter?

3 Answers   TCS,






define steps of assigning items to an organization.

1 Answers   Scan Steel,


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

1 Answers  


What is the interface?

3 Answers  


tell my any difficult situtation you solved in your experience in your company?

0 Answers   Accenture,


Can we run a package with out specification?If yes how?

4 Answers  


link between po and ap modules

5 Answers   ERP Solutions,


why do we validate the records while developing interface?

3 Answers   TCS,


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)