Sir, may i use Group functions in a Cursor.
Declare cursor1 cursor for
select pol-type, sum(pol-amt) from policy
group by pol-type
......
.......
.......
fetch cursor1 into :hv-pol-type, :totamt
......
in above code i get an error is Unusable or Undefined Host Variable "totamt"
here "TOTAMT" is a working-storage variable
what is the reason