Informix Error -4372: The cursor cursor-name has not yet been declared in this program module. It must be declared before it can be used.

Reasons / Common Causes

-4372 fires when a name expected to be a declared cursor or prepared statement hasn't been declared/prepared at that point in the program — per the official guidance, this may be a spelling error, or the DECLARE statement may be in a GLOBALS file that wasn't included.

1. A misspelled cursor/prepared-statement name, per the official guidance — the first named cause.
2. The DECLARE statement is in a GLOBALS file that wasn't included, per the official guidance — the second named cause.

Solutions / Resolution

1. Check the spelling of the name, per the official guidance.
2. Look back in the program to see why it hasn't been declared, per the official guidance — checking whether a GLOBALS file containing the DECLARE was omitted.

Examples

Using a cursor before declaring it

FOREACH cur INTO rec.*
  ...
END FOREACH
-- -4372: cur was never DECLAREd

Corrected

DECLARE cur CURSOR FOR SELECT * FROM orders;
FOREACH cur INTO rec.*
  ...
END FOREACH

Diagnostic Checks

1. Check the cursor/prepared-statement name's spelling, and confirm its DECLARE statement (possibly in a GLOBALS file) has actually been included.

Related Errors / Related Topics

• -4371 — "Cursors must be uniquely declared within one program module." A related cursor-declaration error, about a duplicate declaration rather than a missing one.

A cursor/prepared-statement name is used before being declared — check its spelling and whether its DECLARE (possibly in GLOBALS) was included.