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
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 |
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 |
Answer / muneer
WE CAN PASS 100 PARAMETERS INCLUDING ERRBUF AND RETCODE
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / hamza zaheer
we can pass unlimited parameters in a function...
| Is This Answer Correct ? | 2 Yes | 8 No |
Is SOB is attached with Business grp ?
WHAT IS THE FORWARDREFERENCE IN PL/SQL?
do i need to declare bind parameter before using in the query?
What is procedure?
Can u attach Request set with in the Request set?
What is request group
Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
What is ERP? Architecture of apps?
where we will put the control file ,where we will run sql star loader what is the cmd?
what are the default arguments for pl/sql program?
in procedure how to return a value