SPL1120: "%s:E(L%d), Updatable cursor is not allowed in Teradata mode." - Teradata Database

Stored Procedure Compilation (SPL Prefix) Messages

Product
Teradata Database
Release Number
16.10
Language
English (United States)
Last Update
2018-10-22
dita:id
B035-1096-SPL
lifecycle
archive
Product Category
Teradata® Database

SPL1120: "%s:E(L%d), Updatable cursor is not allowed in Teradata mode."

Explanation:

If a stored procedure is being created in Teradata (BTET) mode, the ANSI mode-specific updatable cursor statement cannot be specified in the SPL source text.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Remove the ANSI mode-specific updatable cursor statement or change the session mode to ANSI before creating the procedure.