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 |
what is the difference between request group and request security in oracle apps?
What are the different components of soa suite?
for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake
Tell me some errors names and number what u got while developing the reports?
name at least five reports in oracle inventory related to transaction ?
How do u identity its name of report?
what is difference between po_headers_all and po_headers
What are the requests groups?
When you run he report you have to get only that particular organization po numbers or item number how can do it?
What is MO operating units. Why it need to to set this and where .
In what situation u create the BPA.
Presently u are working in which version?