Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-36164

(XSMXAGGR07) %a number number
When using the COUNTVAR clause, the number of variables to be aggregated (%1p) must match the number of COUNTVAR variables (%2p).

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