16.20 - SPL1128: "%s:E(L%d), Data type of %s is not compatible with statement or condition information item." - Teradata Vantage NewSQL Engine

Teradata® Vantage - Database Stored Procedure Compilation (SPL Prefix) Messages

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1096-162K

SPL1128: "%s:E(L%d), Data type of %s is not compatible with statement or condition information item."

Explanation:

This error is reported when the datatype of the local variable, parameter, or cursor alias is not compatible with the condition number, condition information item name, or the statement information item name specified in the statement. This error may be reported for GET DIAGNOSTICS, SIGNAL, or RESIGNAL statements. The first %s contains the name of the local variable, parameter, or cursor alias used in the statement. The second %s contains the condition information item name, or statement information item name specified in the statement.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Correct the statement in the stored procedure definition and resubmit the stored procedure for compilation.