Oracle Solution for Error ora-36164

ORA-36164: (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number

) must match the number of COUNTVAR variables (number

).

What triggered the Error:

The user specified a COUNTVAR clause to the AGGREGATE command, but the number of COUNTVAR variables specified did not match the number of variables to be aggregated

What should we do to fix it:

Specify a separate COUNTVAR for each variable