Informix Error -12238: Cannot update Statement Cache entry that is marked as invalid.
Cause and resolution
Cannot update Statement Cache entry that is marked as invalid.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12238 fires when an update is attempted on a statement-cache entry already marked invalid — per the official guidance (the live page documents only the title, with no further body text).
- The targeted statement-cache entry already marked invalid, per the official guidance — the direct, only cause.
Solutions / Resolution
- Re-prepare the statement so a fresh, valid cache entry is created, per the official guidance's implication, rather than updating the invalidated one.
Examples
N/A
No specific triggering statement is documented beyond updating an already-invalid cache entry.
Diagnostic Checks
- Check whether the statement-cache entry is marked invalid, and re-prepare the statement instead of updating it directly.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -12238 in this set yet.
An update targeted a statement-cache entry already marked invalid — re-prepare the statement instead.