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?
- 6 Answers
- 25352 Views
- LG Soft, I also Faced
- E-Mail Answers
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 |
How many schemas we have? how many you have used?
In thet custom.pll what are the events we can write.
What is responsibility and how u attach
How to create user and how u attach with responsibility.
tell me the scenarios of the independent in reports
How to print invoice from APPS(front end).if we have invoice number in hand with us???
what are the error tables in AP?
What is request group
WHAT IS THE FORWARDREFERENCE IN PL/SQL?
explain registration steps of a concurrent program.
what is difference between po_headers_all and po_headers
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
Oracle Apps Technical 
