Database Error Messages

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.