How to fix the Oracle error ORA-36185: (XSAGGR11) workspace object does not have any AGGCOUNT information.?

In this post, you’ll learn more about the Oracle ErrorORA-36185: (XSAGGR11) workspace object does not have any AGGCOUNT information. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36185: (XSAGGR11) workspace object does not have any AGGCOUNT information.

Reason for the Error ORA-36185: (XSAGGR11) workspace object does not have any AGGCOUNT information.

User attempted an operation (such as the AVERAGE aggregation operator or the AGGCOUNT function) that requires a variable to have AGGCOUNT information on a variable that does not.

How to fix the Error ORA-36185: (XSAGGR11) workspace object does not have any AGGCOUNT information. ?

You can fix this error in Oracle by following the below steps

Define the variable using the WITH AGGCOUNT clause, or use the CHGDFN ADD AGGCOUNT command to enable AGGCOUNT for the variable.