Informix Error -35203: Cursor cursor name already defined.

Reasons / Common Causes

-35203 fires when a cursor id is declared more than once — per the official guidance, each cursor id may be used for only one cursor.

1. The same cursor id used in more than one DECLARE CURSOR statement, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Rename the cursor so that it is unique within the module, per the official guidance — unique cursors also enhance portability, per the official text.

Examples

N/A

No specific triggering statement is documented beyond a cursor id declared twice within the module.

Diagnostic Checks

1. Search the module for every DECLARE CURSOR using the named cursor id and confirm it appears only once.

Related Errors / Related Topics

• -35201 — "Cursor name must be an identifier." Another cursor-declaration error, about the name's syntactic validity rather than its uniqueness.
• -35213 — "No cursor declaration for procedure name." The opposite problem: a cursor used without ever being declared.
• -35214 — "Cursor cursor name used with OPEN in more than one procedure." A related cursor-usage restriction.
• -35220 — "No OPEN procedure for cursor name." A related cursor-usage error.

The same cursor id was declared more than once in the module — rename it so it's unique; unique cursor ids also improve portability.