Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Forms 4.5 - Too Many Rows

Re: Forms 4.5 - Too Many Rows

From: Mark <lambicm_at_yahoo.com>
Date: Thu, 06 Aug 1998 14:25:25 +0100
Message-ID: <35C9AEC5.4355@yahoo.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US