select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SQLSTATE / CLASS 22 · DATA EXCEPTION

null_value_no_indicator_parameter

SQLSTATE
22002
Condition name
null_value_no_indicator_parameter
Class
Data Exception
Source macro
ERRCODE_NULL_VALUE_NO_INDICATOR_PARAMETER
Evidence
Definition only
Analysis & operational context

English SQLSTATE atlas: authored explanations and source/runtime evidence are separate from the manual definitions. View source ↗

<h1>22002</h1>

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.

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.

Sources

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

Source evidence

Evidence belongs to the frozen source and runtime versions listed here. It is not a runtime verification of the selected manual version.

22002 is null_value_no_indicator_parameter in SQLSTATE Class 22.

Method: Read fixed definition.

src.errcodes.18.6

The bounded REL_18_6 call archive contains no resolved native report group for 22002.

Method: Search fixed call records for the macro.

Limits: This does not exclude an ECPG, extension, wrapper, or other unscanned path.

src.calls.REL_18_6

The condition name describes a NULL indicator-variable contract associated with embedded SQL/client handling; it is not evidence that a server column NULL alone should produce 22002.

Method: Compare the condition definition with the bounded emitter scan.

Limits: No fixed server message template was confirmed.

src.errcodes.18.6 src.calls.REL_18_6

The locked catalogue records 22002 from 7.4 without proving an exact implementation introduction date.

Method: Use catalogue boundary.

src.errcodes.18.6

Message templates

No extracted message template is attached to this condition.

Reproduction & repair cases

No reproduction case is attached to this condition.

Recorded runtime evidence

No runtime observation is attached to this entry.

Definition snapshot: english-manuals:4d0389d319e9adea98f2a510e9d… · English manual source