Oracle database error code ORA-36185 – (XSAGGR11) workspace object does not have any AGGCOUNT information.

Oracle Database Error Code ORA-36185 Description :
(XSAGGR11) workspace object does not have any AGGCOUNT information.
Error Cause:
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 Solve :
Define the variable using the WITH AGGCOUNT clause, or use the CHGDFN ADD AGGCOUNT command to enable AGGCOUNT for the variable.


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