Informix Error -35220: No OPEN procedure for cursor name.

Reasons / Common Causes

-35220 fires when a statement refers to a cursor that has never been opened — per the official guidance.

1. A statement referencing a cursor with no corresponding OPEN statement anywhere in the module, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Remove the cursor reference if no OPEN is actually needed, per the official guidance's first option.
2. Add an OPEN statement for the cursor, per the official guidance's second option, if the cursor genuinely needs to be opened.

Examples

N/A

No specific triggering statement is documented beyond a cursor referenced without ever being opened.

Diagnostic Checks

1. Search the module for an OPEN statement against the named cursor — if none exists, decide whether the reference should be removed or the OPEN added.

Related Errors / Related Topics

• -35201 — "Cursor name must be an identifier." Another cursor-declaration error.
• -35203 — "Cursor cursor name already defined." A related uniqueness restriction.
• -35213 — "No cursor declaration for procedure name." A related error, about a cursor used without being declared at all, rather than declared-but-unopened.
• -35214 — "Cursor cursor name used with OPEN in more than one procedure." The opposite problem: a cursor opened too many times rather than not at all.

A cursor was referenced without ever being opened — either remove the reference or add the missing OPEN statement.