15.00 - Parameter Names and Data Types - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.