Teradata provides a parameter data type called TD_ANYTYPE that can accept any system-defined data type or UDT. You can specify TD_ANYTYPE as a data type for:
- Input parameters in scalar, aggregate and table functions
- Result parameters in scalar and aggregate functions
- IN, INOUT, or OUT parameters in external stored procedures
- Input parameters and return value in UDMs
You cannot use TD_ANYTYPE as the return type in table functions.
The parameter attributes and return type are determined at execution time based on the actual arguments passed to the routine.