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 -> WebDB & HTTP_ACCEPT_LANGUAGE

WebDB & HTTP_ACCEPT_LANGUAGE

From: Jenda Krynicky <Jenda_at_Krynicky.cz>
Date: Thu, 03 Feb 2000 16:50:35 GMT
Message-ID: <1103_949596635@way>


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

Original text of this message

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