Expand To Show Full Article
Oracle Error ORA-41693: invalid attribute or data type for an aggregate operator: string - Developer Publish

Oracle Error ORA-41693: invalid attribute or data type for an aggregate operator: string

Oracle Error Message

ORA-41693: invalid attribute or data type for an aggregate operator: string

Reason for the Error

An attempt was made to apply an aggregate operator on an invalid attribute or an attribute with invalid or unsupported data type in the aggregate operator. Only NUMBER and DATE attributes are allowed in the aggregate operators.

Solution

Correct the input and try again.