ORA-00979

ORA-00979: not a GROUP BY expression ORA-06512: at "IPP.IPP_GETCURRENTPRICE", line 17 ORA-06512: at line 1

Which points to this statement in a function:

     OPEN cv_1 FOR
         SELECT item_code,
                index_date,
                price,
                currency_code,
                price_basis,
                not_traded,
                price_estimated,
                no_change,
                is_valid
           FROM ipp_price 
          WHERE item_code = v_code
           GROUP BY item_code
         
            HAVING index_date = MAX(index_date);

The value being passed in for v_code is correct. What is it objecting to?

-- 
Tim Slattery
Slattery_T_at_bls.gov