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

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.