Informix Error -9636: Opaque type exceeded its maximum length.
Cause and resolution
Opaque type exceeded its maximum length.
Opaque types are defined with a maximum length that cannot be exceeded. Verify that user-defined routines that return the type do not attempt to exceed the size limit.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-9636 fires when a value of an opaque type exceeds the type's defined maximum length — per the official guidance.
- A user-defined routine returning a value larger than the opaque type's maximum length, per the official guidance — the direct, only cause.
Solutions / Resolution
- Verify that user-defined routines returning the type don't exceed the size limit, per the official guidance.
Examples
N/A
No specific triggering statement is documented; the specific opaque type and its defined maximum length vary.
Diagnostic Checks
- Check the opaque type's
maxlengthdefinition and the UDR's output size, and correct whichever is producing oversized output.
Related Errors / Related Topics
- -9624 — "Maximum length must be greater than zero and smaller than 32,768." A related opaque-type length error, on the CREATE OPAQUE TYPE definition's validity rather than a runtime value exceeding it.
A value of an opaque type exceeded its defined maximum length — check the UDR producing it
against the type's maxlength.