Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Invalid variable declaration.
NOT_ALLOWED_IN_SCOPE
Declaration of the variable <varName> is not allowed in this scope.
ONLY_AT_BEGINNING
Variable <varName> can only be declared at the beginning of the compound.
QUALIFIED_LOCAL_VARIABLE
The variable <varName> must be declared without a qualifier, as qualifiers are not allowed for local variable declarations.
REPLACE_LOCAL_VARIABLE
The variable <varName> does not support DECLARE OR REPLACE, as local variables cannot be replaced.
TABLEREF_CONFLICTS_WITH_TEMP_OBJECT
Cannot declare session TABLEREF variable <varName> because a temporary view or table with the same name exists.
TABLEREF_DEFAULT_NOT_SUPPORTED
DEFAULT values for TABLEREF variables are not yet supported. Use DECLARE ... TABLEREF followed by SET VAR ... = tableName.
TABLEREF_EXECUTE_IMMEDIATE_NOT_SUPPORTED
TABLEREF variables cannot be used as targets of EXECUTE IMMEDIATE INTO.
TABLEREF_INVALID_SOURCE
TABLEREF variables can only be assigned table identifiers (for example, schema.tableName), not expressions or query results.
TABLEREF_MULTIPLE_ASSIGNMENT
Cannot assign multiple variables when using TABLEREF. Only one TABLEREF variable can be set at a time.