M$IE & WebDB - fetch out of sequence

From: Jenda Krynicky <Jenda_at_Krynicky.cz>
Date: Tue, 28 Sep 1999 09:06:17 GMT
Message-ID: <1105_938509577@prague_main>

We have a strange problem here.
We have made a package in PL/SQL to generate some report. It works without any problems in Netscape Navigator3.04, Communicator 4.06 and Opera 3.60. But sometimes fails with Microsoft Exploder (Both 5.0 and 4.0).

Sometimes it works, sometimes I get :

ORA-01002: fetch out of sequence
ORA-06512: on "SYS.DBMS_SYS_SQL", line 786
ORA-06512: on "SYS.DBMS_SQL", line 321
ORA-06512: on "WEBDB.WWV_UI_LOVF", line 286
ORA-06512: on "WEBDB.WWV_UI_LOVF", line 707
ORA-06512: on "MEDIA.UNI_REP1", line 31
ORA-06512: on line 1

The line in question looks like this:

WEBDB.WWV_UI_LOVF.SHOW_AS_COMBOBOX(

        p_lov  => 
         'SELECT NAZEV FROM WIZARD_KODO_UNI GROUP BY NAZEV ORDER BY NAZEV',
        p_show_null => 'NO',
        P_VALUE => NULL,
        p_name => 'P_KOD_LOV',
        p_translation => 'NO');

The table is rather small (99 rows) and is NOT being updated.

Did anyone encounter such a problem? And has some suggestion ?

We have Oracle 8.1i running under WinNT4.0sp4 with WebDB 2.0.5.6.1 (Oracle WebDb Listener 2.0).

Thanks a lot, Jenda
http://Jenda.Krynicky.cz

P.S.: CC: to jenda_at_mccann.cz will be appreciated :-) Received on Tue Sep 28 1999 - 04:06:17 CDT