Oracle Message PLS-01471 - The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr)

ERRORThe keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr)
CAUSEThe keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr). Sect 5.8
ACTIONNone