Oracle Error Message
PLS-00205: Aggregate not allowed here
Reason for the Error
An aggregate, that is, a parenthesized list of values such as (7788, ‘SCOTT’, 20), was found in an inappropriate context.
Solution
Remove or relocate the aggregate.