Link to home
Start Free TrialLog in
Avatar of alsatham hussain
alsatham hussainFlag for India

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
Avatar of Sean Stuber
Sean Stuber

65536 is the upper limit  (  http://docs.oracle.com/database/122/LNPLS/plsql-program-limits.htm#LNPLS018   )

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.
Avatar of alsatham hussain

ASKER

Hi,

please provide simple scenario for using collection


thanks for your time ( thanx, thanx,,,,,)
thank you.
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks for your time