ORA-36160: (XSMXAGGR04) You may not use AGGREGATE on scalar VARIABLE workspace

ORA-36160: (XSMXAGGR04) You may not use AGGREGATE on scalar
VARIABLE workspace object.

Question Posted / guest

1 Answers
2959 Views
I also Faced
E-Mail Answers

ORA-36160: (XSMXAGGR04) You may not use AGGREGATE on scalar VARIABLE workspace object...

Answer / guest

Cause: The user specified a scalar variable to use for AGGREGATE

Action: Specify a dimensioned variable instead

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30753: column or table string is substitutable

1 Answers

LSX-00202: contents of "~S" should be text only

1 Answers

TNS-12593: TNS:no registered connection

1 Answers

ORA-09920: Unable to get sensitivity label from connection

1 Answers

NCR-03026: NCRO: The result buffer has overflowed

1 Answers

QSM-01049: semi-join check failed for materialized view, string

1 Answers

RMAN-04024: trying to start the Oracle instance without parameter files ...

1 Answers

ORA-26001: Index string specified in SORTED INDEXES does not exist on table string

1 Answers

ORA-02280: duplicate or conflicting CYCLE/NOCYCLE specifications

1 Answers

QSM-02082: problem with mv log

1 Answers

TNS-12574: TNS:redirection denied

1 Answers

ORA-39313: illegal clone() call: clone has been done before

1 Answers

For more Oracle Errors Interview Questions Click Here