Informix Error -35214: Cursor cursor name used with OPEN in more than one procedure.

Reasons / Common Causes

-35214 fires when the same cursor is opened from more than one procedure — per the official guidance, cursors can only be referenced in one OPEN statement.

1. The same cursor opened in two or more different procedures, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Remove the multiple open-cursor procedures, per the official guidance, so the cursor is opened from only one place.

Examples

N/A

No specific triggering statement is documented beyond a cursor opened from more than one procedure.

Diagnostic Checks

1. Search the module for every OPEN statement against the named cursor and confirm it appears in only one procedure.

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, at declaration time rather than OPEN time.
• -35213 — "No cursor declaration for procedure name." The opposite problem: a cursor used without ever being declared.
• -35220 — "No OPEN procedure for cursor name." The opposite problem: a cursor never opened at all.

A cursor was opened from more than one procedure — remove the extra OPEN statements so the cursor is opened from only one place.