Oracle Error Messages: the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).

Showing posts with label the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).. Show all posts

Saturday, 9 June 2012

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

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

Cause: 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

Action: Specify a separate COUNTVAR for each variable