ORA-24347 Warning of a Null column in an Aggregated Function and Forms 9i
raelraelApr 23 2004 — edited Apr 27 2004I receive "ORA-24347 Warning of a NULL column in an aggregate function" on a block based on 'FROM query clause'
This happens with a query containing a "count" on the query to check the number of occurences of a certain item on another table.
It can easily be reproduced with a block based on the following query:
select emp.ename,count(bonus.ename) as nn
from emp,bonus
where bonus.ename(+) = emp.ename
group by emp.ename;
:system.last_query runs correctly on SQL Plus
It runs also correctly on my production server (Forms 6i and DB 8.1.6)
I installed all the latest patch sets both for IAS and DS.
My current platform is Windows 2000 SP4, 9iAS 9.0.3.1.0, 9DS 9.0.2.3.0 (Forms and Reports).
Any help ?
Thank you and regards
Patrick Morganti