too_many_rows
915741May 24 2012 — edited May 24 2012form version 10g
hi,
suppose my single row select statement returned more than one row. and i trap this using too_many_rows.
can i use the data of every row(returned as to many rows) for further calculation like
exception when too_many_rows then
process data of first row
process data of second row
.......
.....
end;
or i need to use cursor like
exception when too_many_rows then
for cursor in ( my select statement)
loop
process the data
end loop;
end;
i mean is there any way to access and use those data without using cursor in this case ???