Re: LOV Error: More Info

Hi Greg,

What is find disturbing this everything run great in WebDB 2.1. Upgaded to WebDB 2.2.0.0.5 and this LOV does not work in a form. In addition, the POP does not work either in any case. The pop does not do anything when you select or double click on the desired item.

-Brooks

Greg wrote:

> I donth think its very useful to have such an amount of records
> in a combo box, first its slow to load (all datas are in the HTML code)
> and second its hard to find THE ONE
> why U dont use a popup instead.
>
> To try I had replaced one of my popup in a form by
> a combo box worked fine with 1722 records.
>
> Maybe some other problems
>
> Brooks Vaughn wrote:
>
> > It seems that there is a limit of some Sort. When there is over 780 entries
> > in the LOV, it fail with the error below.
> >
> > Brooks Vaughn wrote:
> >
> > > We are currently using WebDB 2.2.0.0.5 installed as a cartridge under
> > > OSA 4.0.8.1.
> > >
> > > It seems to occur when I run this form that contains this LOV (contains
> > > the a List of all our Users), as a ComboBox, I get the error shown
> > > below.. The LOV works great in the testlov of Webdb and it also worked
> > > fine with WebDB 2.1.x.
> > >
> > > -Thank you, Brooks Vaughn
> > >
> > > 18/Jul/2000:14:14:27
> > >
> > > ORA-06502: PL/SQL: numeric or value error
> > > ORA-06512: at "WEBDB.WWV_UI_LOVF", line 1037
> > > ORA-06512: at "WEBDB.WWV_UI_LOVF", line 723
> > > ORA-06512: at "WEBDB.WWV_UI_DISPLAY", line 198
> > > ORA-06512: at "WEBDB.WWV_UI_FORM", line 924
> > > ORA-06512: at "WEBDB.WWV_RENDER_ADVANCEDFORM", line 291
> > > ORA-06512: at "ITM_WEB.CAL_ACCESS_FRM04E", line 177
> > > ORA-06512: at line 5
> > >
> > > DAD name: webdbtest
> > > PROCEDURE : ITM_WEB.CAL_ACCESS_FRM04E.show
> > > USER : bvaughn
> > > URL :
> > > http://server:3300/testweb/webdbtest/ITM_WEB.CAL_ACCESS_FRM04E.show
> > > PARAMETERS :
> > > ===========
> > >
> > > ENVIRONMENT:
> > > ============
Received on Wed Jul 19 2000 - 00:00:00 CEST