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
2939 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

LPX-00100: root element "~1S" does not match DTD root "~2s"

1 Answers

PCC-00027: Redeclared SQL Identifier "string" at line number in file string

1 Answers

LPX-00013: wrong node type

1 Answers

ORA-07860: osnsoi: error setting up interrupt handler

1 Answers

ORA-19603: cannot backup or copy active file with KEEP .. UNRECOVERABLE option

1 Answers

SQL*Loader-00135: Invalid argument for RESUMABLE

1 Answers

RMAN-06719: file "string" (string bytes) restrieved from catalog

1 Answers

ORA-31204: DBMS_LDAP: PL/SQL - Invalid LDAP Session.

1 Answers

NNC-00050: message format error

1 Answers

ORA-16133: Datafile string has incorrect terminal recovery stamp.

1 Answers

QSM-01074: materialized view, string, and query have different no of joins between tables, string

1 Answers

ORA-02839: Sync of blocks to disk failed.

1 Answers

For more Oracle Errors Interview Questions Click Here