Skip to content

22002 — null_value_no_indicator_parameter

Source-backed reference for PostgreSQL SQLSTATE 22002.

22002

At a glance

22002 is null_value_no_indicator_parameter, an ECPG-oriented condition. The fixed 18.6 call archive has no resolved native report group in this scan.

Field Value
SQLSTATE 22002
Condition null_value_no_indicator_parameter
Status active
Known present by 7.4
Locked snapshots 9.0.23, 9.1.24, 9.2.24, 9.3.25, 9.4.26, 9.5.25, 9.6.24, 10.23, 11.22, 12.22, 13.23, 14.24, 15.19, 16.15, 17.11, 18.6, 19beta3
Macros ERRCODE_NULL_VALUE_NO_INDICATOR_PARAMETER
Aliases

Meaning

22002 is null_value_no_indicator_parameter, an ECPG-oriented condition. The fixed 18.6 call archive has no resolved native report group in this scan.

Messages

No fixed PostgreSQL primary, DETAIL, HINT, or severity was confirmed in the bounded call scan. runtime_verification is not_run; a client or ECPG implementation that reports this code must supply its own exact diagnostic context.

Diagnosis

Locate the ECPG/preprocessor or client path that selected 22002 and inspect its indicator-variable contract; do not infer it from a server column NULL alone.

Response

Supply the required indicator handling in the actual ECPG interface or correct the client binding. Keep this code separate from ordinary column NOT NULL and PL/pgSQL NULL conditions. No server transaction-recovery rule is inferred from this source-only page.

Versions

The locked catalogue records this condition from 7.4 in the listed formal snapshots and 19beta3; fixed source coverage is PostgreSQL 18.6.

22000, 22001, 22003, 22004

Sources

See the fixed source links and scope limits in the structured evidence record.