The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr) PLS-01471 – Oracle Error Code Tagged on: oracle error pls-01471 PLS-01471 pls-01471 error code