skip to main content
Designing and coding the IP : User defined scalar functions : Variable number of arguments
 

Variable number of arguments

The scalar function can be defined to accept a variable number of arguments. This is done by setting the number of arguments to be a negative number in the scalar_functions array. The user can then use the scalar function and pass any number of arguments with a maximum of (args*-1) arguments. For example, if you would like to accept up to three arguments in a function, set the number of arguments to be (–3).