Description:
ORA-35276 (SNSYN163) The format of the ALLOCATE command is: ALLOCATE varname [SOURCE svarname] [BASIS bvarname [ACROSS dimname]] [TARGET tvarname [TARGETLOG logvarname]] USING aggmap
Cause:
The user used incorrect syntax for the ALLOCATE command.
Description:
ORA-35280 (SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 ...] USING aggmap-name [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 ...]] [FUNCDATA] [THREADS #]
Cause:
The user used incorrect syntax for the AGGREGATE command.
Description:
ORA-35282 (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname USING aggmap-name [COUNTVAR intvar-name] [FORCECALC])
Cause:
The user used incorrect syntax for the AGGREGATE function.
Description:
ORA-36178 (XSAGGR01) To be used with AGGREGATE, AGGMAP workspace object must be declared with the AGGMAP command.
Cause:
The user used the ALLOCMAP command to define the AGGMAP, so the AGGMAP can only be used with the ALLOCATE command, or the AGGMAP has no contents attached to it.
Description:
ORA-36180 (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
Cause:
When using AGGREGATE, only simple permissions and permissions on base dimensions are valid.
Description:
ORA-36182 (XSAGGR09) %a workspace object number Could not locate a value for variable %p in measure dimension %p.
Cause:
A measure dimension was supplied in the AGGMAP, but a position for the variable was not found in it.
Description:
ORA-36184 (XSAGGR10) You do not have sufficient permissions for the variable workspace object.
Cause:
The user lacked the permissions necessary for the aggregation variable.
Description:
ORA-36188 (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is a problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle Support Services.
Cause:
Either someone improperly changed the COUNTVAR variable, or AGGREGATE has an error.
Description:
ORA-36198 (XSAGGR33) %a string workspace object number workspace object The AGGREGATE operator %p does not require a weight, but ARGS variable %p with text ‘number‘ specified %p as a weight.
Cause:
The ARGS variable specified a weight even though one is not needed.
Description:
ORA-36200 (XSAGGR34) %a string workspace object string AGGREGATE operator %p requires a WEIGHTBY clause, but ARGS variable %p did not specify one with text expression “%p“.
Cause:
The given operator requires a WEIGHT specification, but the ARGS variable did not supply one.