15.00 - Parameter Names and Data Types - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

Parameter Names and Data Types

See “Parameter Names and Data Types” on page 258.

While you can specify the TD_ANYTYPE data type for table function parameters, you cannot specify TD_ANYTYPE as the return data type for a table function.

Note that unlike the case for the RETURNS TABLE clause, you must stipulate an AS LOCATOR phrase for any LOB parameter data types you specify in the parameters clause of a table function.