SPL5005: "%s:E(L%d), FETCH not allowed for a WITH RETURN ONLY cursor %s ." - 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

SPL5005: "%s:E(L%d), FETCH not allowed for a WITH RETURN ONLY cursor %s ."

Explanation:

FETCH is not allowed on a Cursor declared as WITH RETURN ONLY.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Remove the ONLY clause.