WebDB & HTTP_ACCEPT_LANGUAGE

I have some problems with WebDB.

As soon as I add "Czech [cz]" into the accepted languages in Microsoft Internet Explorer, WebDB starts to report errors.

1.

ORA-01002: fetch out of sequence
ORA-06512: at "SYS.DBMS_SYS_SQL", line 786
ORA-06512: at "SYS.DBMS_SQL", line 321
ORA-06512: at "WEBDB.WWV_UI_LOVF", line 316
ORA-06512: at "WEBDB.WWV_UI_LOVF", line 909
ORA-06512: at "MEDIA.UNI_REP1", line 149
ORA-06512: at line 1

The line 149 in UNI_REP1 is :

     WEBDB.WWV_UI_LOVF.SHOW_AS_COMBOBOX(
        p_lov  =>


           'SELECT DISTINCT NAZEV FROM WIZARD_KODO_UNI WHERE CUSTOM = '''||L_KLIENT||''' ORDER 


BY NAZEV',
        p_show_null => 'NO',
        P_VALUE => NULL,
        p_name => 'P_KOD_LOV',
        p_translation => 'NO');

I tried to find the problem, but got lost in the code. I tried to wrap lines 315-317 in WEBDB.wwv_ui_lovf into a

   BEGIN
     ...
    exception when others then
     return false;
   END; As a dirty "solution". It seemed to help for this problem, but the report still fails :

ORA-00600: internal error code, arguments: [17182], [153768192], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SYS_SQL", line 480
ORA-06512: at "SYS.DBMS_SQL", line 19
ORA-06512: at "WEBDB.WWV_UI_LOVF", line 271
ORA-06512: at "WEBDB.WWV_UI_LOVF", line 941
ORA-06512: at "MEDIA.UNI_REP1", line 42
ORA-06512: at line 1

The command on line 42 is :

    WEBDB.WWV_UI_LOVF.SHOW_AS_COMBOBOX(

        p_lov  =>


           'SELECT DISTINCT UPPER(CUSTOM) "NADPIS", CUSTOM "KLIENT" 


FROM media.WIZARD_KODO_UNI',
        p_show_null => 'NO',
        P_VALUE => NULL,
        p_name => 'P_KLIENT',
        p_translation => 'NO');

If I then press reload I often get

ORA-03114: not connected to ORACLE

but the server goes on happily and as soon as I delete the "Czech [cz]" and reload everything works all right.

Could someone more knowledgable than me look at WebDB and find the problem? I can delete the accepted language on our computers, but can't access clients :-(

P.S.: I've tried to set some other languages ... seems that the only one with that WebDB works is English. I tried German for example and got the same error.

Jenda
http://Jenda.Krynicky.cz Received on Thu Feb 03 2000 - 10:50:35 CST