Error ORA-00979: not a GROUP BY expression
445844Jan 25 2006 — edited Jan 27 2006Hello,
I have the error ORA-00979 not a GROUP BY expression when I execute this SQL sentence within Oracle Form 6i + Patch 17, but in SQL Plus it works fine:
SELECT min(num_linea) num_linea, dato
FROM datos_transferencia_out
WHERE orden = 1
GROUP BY dato
HAVING count(*) > 1
ORDER BY num_linea, dato
In Oracle Forms doesn't works if it is declared within a cursor, but if I execute directly doesn't works too.
How can I resolve the problem?
The database version is a 9.2.0.1.0.
Thank you very much,
Jordi