Informix Error -11354: Any open cursors are now invalid and must be closed before being used.
Cause and resolution
Any open cursors are now invalid and must be closed before being used.
This Informix ODBC error code is the same as SQLSTATE value 01000. The following functions can return this error code: SQLExecDirect, SQLExecute, and SQLSetConnectAttr.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-11354 fires as an informational warning that a preceding operation invalidated open
cursors on the connection — per the official guidance, this is the same as SQLSTATE value
01000, returnable by SQLExecDirect, SQLExecute, and SQLSetConnectAttr.
- A statement or connection-attribute change (e.g. isolation level, transaction state) that invalidates existing open cursors, per the official guidance — the direct, only cause.
Solutions / Resolution
- Close any open cursors before reusing them, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an operation invalidating open cursors.
Diagnostic Checks
- Close all open cursors on the connection, and reopen them fresh before continuing.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -11354 in this set yet.
An operation invalidated open cursors on the connection — close and reopen them before reuse.