We have a customer who is getting
ORA-24347: Warning of a NULL column in an aggregate function
Query they are running is:
SELECT (NVL(Sum(BudgetDet_Fixed_Amt),0)), (NVL(Sum(BudgetDet_Actual_Amt),0)),
and ((BudgetDet_Type=2 and BUDGETDET_MILESTONE in (0,10))or BudgetDet_Type=4)
and BudgetDet_Project_ID=3205 ;
They have Oracle 126.96.36.199. I looked in Metalink for this error message, they say that this bug was created in 8.1.6 and is fixed in 8.1.7. Does any one know why I am getting this error ? Did Oracle really fixed this ?
They asked me to change it to so by doing that they will not get this error
Select SUM(NVL(xx,0)), ....
Select NVL(SUM(xx), 0), ....
But I cannot do it because if there is no row returned by this select SUM(NVL(.... returns NULL