Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Forms 4.5 - Too Many Rows
Nick Lehane wrote:
> I am having a problem with a Too_Many_Rows exception which arises
> because of the following:
>
> I supply a ref no in a control text item and have a button which has a
> When Button Pressed event that searches the database and populates a
> block of display items.
Ideally, you should let forms do the work, by setting the where clause on the multi-row block and doing an execute_query. If for some reason you can't do this then you will need to do everything manually, looping with a cursor and doing next_record calls. Received on Thu Aug 06 1998 - 08:25:25 CDT
![]() |
![]() |