The parameter list of a table function is similar to the parameter list of a scalar function. The main difference is that the table function parameter list can include multiple result parameters because a table function returns a row result instead of just one value.
A table function can have:
- 128 input parameters
- The number of result parameters defined by the RETURNS TABLE clause of the CREATE FUNCTION or REPLACE FUNCTION statement for the table function.
The number of result parameters is limited by the maximum number of columns that can be defined for a regular table.
The data type of a result parameter in a table function cannot be TD_ANYTYPE.