1 Reply Latest reply on Dec 3, 2012 8:51 AM by Prabodh

    Not a group by expression on procedure

      Hi All,

      i have a procedure with this query inside:
      select cd_operatore, cd_commessa, cd_categoria
         into cdOperatore, cdCommessa, cdCategoria
                    from reg_attivita_1
                   group by cd_operatore, cd_commessa;
      As you can see on select i have 3 fields and in group by i have 2.

      If i run this query on session i get the right error:
      ORA-00979: not a GROUP BY
      But if i compile this on procedure/package/function i dont have any error..

      This isnt an syntax error ? Why compier dont tell me this error ?