Re: Oracle forms ver 6 - execute_query does not work

From: DA Morgan <>
Date: Sat, 21 Apr 2007 12:30:33 -0700
Message-ID: <> wrote:
> Hi,
> I have an Oracle table called missawb.
> On my oracle form I have a group of text fields that repesent the
> table. It displays
> 10 rows at a time with a scrollbar.
> I have a button on the form that loads the missawb table via a stored
> procedure:
> dropout_pkg.misspayment(30);
> Then does the following:
> go_block('MISSAWB');
> execute_query(ALL_RECORDS);
> Now the table has been loaded with 44,000 records so I would expect
> that the
> scrollbar is enabled but it is not.
> However if I do the F7/F8 combination on the missawb block - the
> scrollbar is enabled and
> works!
> Can someone please tell me why the execute_query does not enable the
> scrollbar?

I've never seen this behavior before but then I haven't seen Forms 6 in many years. Any chance you can upgrade to a supported version?

Daniel A. Morgan
University of Washington
(replace x with u to respond)
Puget Sound Oracle Users Group
Received on Sat Apr 21 2007 - 21:30:33 CEST

Original text of this message