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 difference between d2k report and oracle apps report
what u did after ur btech(2009) till now? why did u prefer oracle apps technical?
Do you know what is applysys in oracle application database schema, what is apps?
cursor 1 and cursor 2 are there did you open both the cursors at a time or not?
i have 3 parameters like p1,p2,p3.In p1 i have 2 parameters like a,b.if pass parameter 'a' p2 should be enable and p3 should be disable then if pass parameter 'b' the vice versa.
1 Answers IBM, Sierra Atlantica,
What are the requests groups?
What is the difference between BPA AND Contract.
In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?
wheather discard file is automatically created or explicty created?can u mention it?
How we print the multi language in report?can any one give me step bye step explanation.
2 Answers HCL, IBM, Tech Mahindra,
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
we have clients in different countries, we can run report in different places, if i want to display particular language,country,currency everything displays for that country how?