This discussion is archived
1 Reply Latest reply: Dec 3, 2012 12:51 AM by Prabodh RSS

Not a group by expression on procedure

977551 Newbie
Currently Being Moderated
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 ?



  • Correct Answers - 10 points
  • Helpful Answers - 5 points