-501 Referenced cursor is not open - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 (SPP Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Preprocessor2 for Embedded SQL
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2020
Language
English (United States)
Last Update
2023-11-20
lifecycle
Latest
Product Category
Teradata Tools and Utilities

-501 Referenced cursor is not open

Possible Cause

The cursor referenced has been declared, but is not open.

Possible Solution

Open the cursor prior to cursor processing. If not explicitly closed (i.e., CLOSE request, COMMIT request, or an explicit ABORT/ROLLBACK request), verify that an implicit rollback did not occur. (An implicit rollback closes all open cursors associated with the current transaction.)