Oracle Error ORA-36022: (XSHIERCK04) Valuesets specified in the HIERCHECK command must be scalar. workspace object is dimensioned.

Oracle Error Message

ORA-36022: (XSHIERCK04) Valuesets specified in the HIERCHECK command must be scalar. workspace object is dimensioned.

Reason for the Error

The HIERCHECK command specified a dimensioned valueset.

Solution

Specify a scalar valueset in its place.