1 Reply Latest reply: Dec 3, 2012 2:51 AM by Prabodh RSS

    Not a group by expression on procedure

    977551
      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 ?

      Thanks