CURSOR my_cursor IS
SELECT avg(a) avg_a,avg(b) avg_b, avg(c) avg_c, avg(d) avg_d
FETCH my_cursor INTO my_row;
Originally posted by andrewst
When I said "post it" I meant cut and paste it here. You can do that, surely? Impossible to debug code that we can't see!
Gotta agree with Andrew. When fetching into a rowtype or table you must have unique column names. Giving an alias as he provided will take care of that error. Oracle is having trouble determining which column to fetch into the ROWTYPE variable.