ORA-60800
Unsupported ORDER BY expression data type (string) for window functions using RANGE to specify the window frame extent as a logical offset
Cause
An attempt is being made to define a window function using RANGE to specify the window frame extent as a logical offset and the specified ORDER BY expression is of an unsupported data type.
Action
Change data type of the ORDER BY expression which allows addition and subtraction operations, for example they must be numeric, datetime, or interval data types.