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 sequence i want to 11 and 15th values how we will write?

0 Answers  


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

0 Answers   Tech Mahindra,


where the accounting related data is stored ? all type of accounting related data costing etc...

3 Answers  


in one report using two layout models.if yes how to do

3 Answers   Wipro,


how to debug the report?

2 Answers   IBM, Qualcomm, Sierra Atlantica,






In custom.pll what are the events we can Not write.

1 Answers  


HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

2 Answers  


What is SRW Package? (Sql Report Writer)

1 Answers  


In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  


Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  


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

4 Answers  


Can u give the Documentation of Custom.pll in oracle apps

0 Answers  


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)