I agree the suggestions sound a bit like patch work to me too. I have been in Oracle DB and Forms development for a decade and rather get my design fixed than my fetches. If there is a chance of TOO_MANY_ROWS then there must be a reason for it. The only time I ever use TOO_MANY_ROWS is on legacy applications and then the exception block contains a severity log call.
As for the TOO_MANY_ROWS vs. cursor handling, a third option is also missing -- BULK COLLECT ...
Keep Up with TechRepublic