USER_DEFINED_FUNCTIONS error class
User defined function is invalid:
CORRELATED_REFERENCES_IN_SQL_UDF_CALLS_IN_DML_COMMANDS_NOT_IMPLEMENTED_YET
This command includes calls to SQL user-defined function <functionName>
which contains subquery expressions with correlated outer references; this feature is is not implemented yet
NOT_A_VALID_DEFAULT_EXPRESSION
The DEFAULT
expression of <functionName>
.<parameterName>
is not supported because it contains a subquery.
NOT_A_VALID_DEFAULT_PARAMETER_POSITION
In routine <functionName>
parameter <parameterName>
with DEFAULT
must not be followed by parameter <nextParameterName>
without DEFAULT
.
NOT_NULL_ON_FUNCTION_PARAMETERS
Cannot specify NOT NULL
on <languageName>
function parameters: <input>
SQL_TABLE_UDF_BODY_MUST_BE_A_QUERY
SQL table function <name>
body must be a query.
SQL_TABLE_UDF_MISSING_COLUMN_NAMES
The relation returned by the query in the CREATE FUNCTION
statement for <functionName>
with RETURNS TABLE
clause lacks explicit names for one or more output columns; please rewrite the function body to provide explicit column names or add column names to the RETURNS TABLE
clause, and re-run the command.
SQL_UDF_RETURNS_CLAUSE
Must specify an explicit RETURNS
clause for user-defined <functionType>
function.
UNEXPECTED_ENVIRONMENT_SETTINGS
Unexpected environment settings for <languageName>
user defined functions: <invalidKeys>
(valid settings are: <validKeys>
). Update the ENVIRONMENT
clause and try again.