Informix Error -1815: No type information for collection or row is available.
Cause and resolution
No type information for collection or row is available.
The application needs to declare a typed collection or row host variable before using it in an SQL statement. The application can fetch the complex type data from a column of type set, type list, type multiset or type row into their untyped collection or row host variable before it uses the data in the SQL statements.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-1815 fires when a collection or row host variable is used without having been declared with a specific type — per the official guidance, the application needs to declare a typed collection or row host variable before using it in an SQL statement.
- A generic (untyped) collection/row host variable used where a typed declaration is required, per the official guidance — the direct, only cause.
Solutions / Resolution
- Declare a typed collection or row host variable, per the official guidance, before using
it in the SQL statement, matching the actual
SET/LIST/MULTISET/ROWtype involved.
Examples
An untyped collection variable
collection *items;
-- -1815: no type information (e.g. SET(INTEGER)) is associated with items
Corrected — a typed declaration
$SET(INTEGER) *items;
Diagnostic Checks
- Check whether the collection/row host variable has a specific type declaration, and add one matching the actual complex type involved.
Related Errors / Related Topics
- -1814 — "Need to allocate collection or row variable before using it." A related complex-type error, about a missing allocation rather than a missing type declaration.
- -1816 — "No such column exists in the collection or row." A related complex-type error, about a field name not matching the declared row/collection description.
The collection/row host variable lacks a typed declaration — declare it with its specific complex type before use.