Oracle database error code ORA-36163 – (XSMXAGGR06) The AGGREGATE function cannot be run on more than one variable at a time.

Oracle Database Error Code ORA-36163 Description :
(XSMXAGGR06) The AGGREGATE function cannot be run on more than one variable at a time.
Error Cause:
The user named several variables to be AGGREGATED within a call to the AGGREGATE function.

How to Solve :
The AGGREGATE function should be used to produce a single numeric value from aggregating a single variable. The AGGREGATE command can be used to precompute aggregations of several different variables.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»