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 |
In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?
what is difference between d2k report and oracle apps report
10 Answers Seven Hills, Wipro,
HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?
I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????
I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.
In thet custom.pll what are the events we can write.
In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?
HOW U DISPLAY THE FLEXFIELD DATA IN APPS?
In unix Schell sript what is very 1st line to be wriiten .
what is aim methodolozy
how many groups we can create for query?
What do you understand by soa and what are the benefits of using this architecture?