Oninit
Talk to an expert →

Informix Error -9637: Cast function (function_name) does not exist.

Cause and resolution

Cast function (function_name) does not exist.

The function associated with a cast must exist when the cast is executed. Use the CREATE FUNCTION statement to create the function.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9637 fires when the function a cast depends on doesn't exist at the time the cast is executed — per the official guidance.

  1. The cast's associated function missing (e.g. dropped after the cast was created), per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Use the CREATE FUNCTION statement to create the function, per the official guidance.
Examples
N/A

No specific triggering statement is documented; the named function varies.

Diagnostic Checks
  1. Check the system catalog for the cast's associated function, and recreate it with CREATE FUNCTION if missing.
Related Errors / Related Topics
  • -9634 — "No cast from ." The general no-such-cast error this is a specific case of, for the function backing an existing cast.
  • -9635 — "An attempt has failed to convert an opaque type into another type without a cast function." A related missing-cast-function error, specific to opaque-type conversions.

The function backing a cast no longer exists — recreate it with CREATE FUNCTION.