Parameter Size

parameter size nn

where nn specifies the maximum size of any single IN-type parameter or local variable used in an application program’s procedures.

IN parameters and local variables are stored internally as VARCHAR variables with a maximum size of nn. If the size of any IN parameters or local variables is larger than the default value of nn, increase nn. Conversely, if all parameters are significantly smaller than the default size, reduce nn to save memory.