PLS-00604: aggregate function is not allowed here
Answer / guest
Cause: One of the functions, such as AVG, COUNT, MAX, MIN,
SUM, STDDEV or VARIANCE, was used in a WHERE or GROUP BY clause
Action: Remove the group function from the WHERE or GROUP BY
clause. The desired result may be achieved by including the
function in a subquery or HAVING clause.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-14069: invalid TABLESPACE_NUMBER value
ORA-37129: (XSCCOMP04) The AGGMAP workspace object cannot be used to aggregate the VARIABLE workspace object. All static MODEL statements must precede all RELATION statments over the bases of the COMPRESSED COMPOSITE.
ORA-01493: invalid SAMPLE size specified
ORA-15019: discovered duplicate path 'string' for 'string'
ORA-04020: deadlock detected while trying to lock object stringstringstringstringstring
ORA-24757: duplicate transaction identifier
SQL*Loader-00459: error fetching numeric value for sequence on column (string)
RMAN-06077: datafile string is a different version than contained in the controlfile
ORA-24350: OCI call not allowed
ORA-14278: column type or size mismatch in EXCHANGE SUBPARTITION
ORA-07596: sptpa: $GETJPIW failure
EXP-00028: failed to open string for write