Re: LOV Error: More Info

[Quoted] 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:
> > ============
>
> --
> +------+
> For Personal Contacts and Interests!
> Brooks Vaughn
> 3204 Bunker Hill Road, Mt. Rainier, MD 20712-1919
> Voice: 301-864-6513, Fax: 301-864-6513,*2 (if necessary)
> MailTo:brooks_at_tidalwave.net
> ICQ Uin# 126670
> Personal Web: <http://www.tidalwave.net/~brooks/>
> US Servas Web Site: <http://www.servas.org>
> +------+
> For Official US Government Business Only!
> Brooks Vaughn
> Federal Trade Commission
> 6th St. & Pennslyvania Ave. NW
> Rm H-603 / Mail Stop H-602
> Washington, DC 20580
> Voice: 202-326-2215, Fax: 202-326-3066
> MailTo:bvaughn_at_ftc.gov, Web Site: <http://www.ftc.gov>
> +------+
Received on Wed Jul 19 2000 - 00:00:00 CEST