15.00 - -501 Referenced cursor is not open - Teradata Tools and Utilities

Teradata Preprocessor2 (SPP Prefix) Messages

prodname
Teradata Tools and Utilities
vrm_release
15.00
category
Programming Reference
featnum
B035-1096-015K

-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.)