alsatham hussain
asked on
What are the limitations of input parameters in oracle ?
Hi,
SQL Server may support up to 2100 parameters – but that does not imply that it is a good idea to actually use them!
What are the limitations of input parameters in oracle ?
Can i pass how-many input parameters in procedure or function
how can i improve performance of input parameters on procedure or function ?
If i passed 1000 of parameters as a input, Will it cause any inconvenience?
Can anybody help me
SQL Server may support up to 2100 parameters – but that does not imply that it is a good idea to actually use them!
What are the limitations of input parameters in oracle ?
Can i pass how-many input parameters in procedure or function
how can i improve performance of input parameters on procedure or function ?
If i passed 1000 of parameters as a input, Will it cause any inconvenience?
Can anybody help me
ASKER
Hi,
please provide simple scenario for using collection
thanks for your time ( thanx, thanx,,,,,)
thank you.
please provide simple scenario for using collection
thanks for your time ( thanx, thanx,,,,,)
thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for your time
but that's silly
if you want to pass a bunch of values, then do it as a single parameter that is of a collection type
so, for example = pass a collection of 1000 items, not 1000 individual items.