Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

too_many_rows

915741May 24 2012 — edited May 24 2012
form 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 ???

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 21 2012
Added on May 24 2012
2 comments
1,026 views