SPL1132: "%s:E(L%d), %s cursor is not specified as scrollable." - 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

SPL1132: "%s:E(L%d), %s cursor is not specified as scrollable."

Explanation:

The user has specified a FETCH statement with fetch orientation other than NEXT, without specifying SCROLL in cursor declaration, which is not allowed.

Generated By:

TSP modules.

For Whom:

End User.

Remedy:

Correct the cursor declaration statement or the FETCH statement in the stored procedure definition and resubmit the stored procedure for compilation.