Informix Error -9635: An attempt has failed to convert an opaque type into another type without a cast function.

Cause and resolution

An attempt has failed to convert an opaque type into another type without a cast function.

The specified cast does not exist or the cast function does not exist. Use the CREATE CAST statement to define the cast or to create the cast function.

The BOOLEAN, BLOB, CLOB, and LVARCHAR data types are implemented by the database server as built-in opaque data types.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9635 fires when converting an opaque type to another type is attempted with no cast function available — per the official guidance; note that BOOLEAN, BLOB, CLOB, and LVARCHAR are themselves implemented as built-in opaque types.

The cast or cast function not existing for the conversion, per the official guidance — the direct, only cause.

Solutions / Resolution

Use the CREATE CAST statement to define the cast, per the official guidance.
Or create the cast function, per the official guidance.

Examples

N/A

No specific triggering statement is documented; the specific opaque type and target type vary.

Diagnostic Checks

Check the system catalog for a cast between the source opaque type and target type, and create one with CREATE CAST if missing.

Related Errors / Related Topics

-9634 — "No cast from ." The general no-such-cast error this is a specific case of, for opaque-type conversions.
-9637 — "Cast function (function_name) does not exist." A related missing-cast error, on the cast function specifically rather than the cast itself.

An opaque-type conversion had no cast function available — define one with CREATE CAST.