i have the table :transactio , dtrans
the structure of transaction is
(g_no,pro_no,unit,count,amount,exp_date)
the structure of dtrans is
(g_no,pro_no,unit,count,amount)

declare
beging
delete from dtrans;
insert into dtrans
select g_no,pro_no,unit,sum(count),sum(amount) from transaction
where to_char(exp_date,'yyyy) = 2006
group by g_no , pro_no,unit;
end;
/
الرسالة بتقول not asingle-group group function
علما بان نفس عملية الادخال تتم بنجاح اذا اجريتها فى الsql وتفشل عند كتابتها فى plsql block
ارجو المساعدة

اخى الكريم زود group by count,group by amount
وشوف ايه النتيجة