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



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-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled

1 Answers  


ORA-28593: agent control utility: command terminated with error

1 Answers  


ORA-00266: name of archived log file needed

1 Answers  


NNL-00237: Resetting of statistic counters is currently disabled

1 Answers  


LRM-00107: parameter name abbreviation 'string' is not unique

1 Answers  






ORA-31662: metadata transform name can not be defaulted

1 Answers  


NNL-00408: Answers:

1 Answers  


ORA-30691: failed to allocate system resources while registering a TCP/IP connection for data traffic detection

1 Answers  


ORA-29900: operator binding does not exist

1 Answers  


ORA-19729: File string is not the initial version of the plugged in datafile

1 Answers  


ORA-02183: valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }

1 Answers  


ORA-14553: cannot perform a lob write operation inside a query

1 Answers  


Categories