Oninit
Talk to an expert →

Informix Error -9967: Cannot find data type data_type_name.

Cause and resolution

Cannot find data type data_type_name.

The specified data type does not exist in the database. Check sysxtdtypes to make sure that the data type exists before you use it.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9967 fires when the named data type doesn't exist in the database — per the official guidance.

  1. The named data type not registered in the database, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Check sysxtdtypes to make sure the data type exists before using it, per the official guidance.
Examples
Checking an extended type's existence
SELECT name FROM sysxtdtypes WHERE name = 'my_type';
Diagnostic Checks
  1. Check sysxtdtypes for the named data type, and create it or correct the reference if missing/misspelled.
Related Errors / Related Topics
  • -9628 — "Type (type_name) not found." The same class of type-not-found error, for general type references rather than a specific data-type lookup.

The named data type doesn't exist — check sysxtdtypes and create it or correct the reference.