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

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.