How to fix the Oracle error PCC-02364: Host struct and its indicator must have the same number of fields?

In this post, you’ll learn more about the Oracle ErrorPCC-02364: Host struct and its indicator must have the same number of fields with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-02364: Host struct and its indicator must have the same number of fields

Reason for the Error PCC-02364: Host struct and its indicator must have the same number of fields

Cause: When a structure containing indicator variables is declared and associated with a host structure, the indicator structure must contain the same number of fields as the host structure. This is so even when some of the indicators will not be used or even when it would not make sense to do so (for fields constrained as NON NULL, for example).

How to fix the Error PCC-02364: Host struct and its indicator must have the same number of fields ?

You can fix this error in Oracle by following the below steps

Action: Redeclare the indicator variable with the correct number of fields.