Oracle 8i & NT 4.0: Bug!

Hi there,

    We have developed an application for P&U (Biostatistics and Data Management, Italy), based upon Microsoft Windows NT 4.0 and Oracle8i Enterprise Edition Release 8.1.5.0.0. We have detected a bug in the software cited, that causes the operating system handles number and/or resources allocated to increase and never decrease until the application crashes. The bug has been defined as such by the italian Oracle Support Team.

We would like to know if the problem arises also in other platforms.

The following java class, stored in Oracle8i as a java stored procedure and called in an infinite loop, allows the problem to be detected.

The java class:

public class Test {

    public static String request(String string) throws Exception {

        return string;
    }
}

The pl/sql package to “publish” the java class in the dbms:

create or replace package Test as

    function request(stringa IN varchar2) return VARCHAR2; end;
/

create or replace package body Test as

    function request(stringa IN varchar2) return VARCHAR2 as     language java name 'Test.request(java.lang.String) return java.lang.String';
end;
/

The infinite loop:

declare

    dummy varchar2(100);
begin

    while TRUE LOOP

        select Test.request('Hello') into dummy from dual;     end loop;
end;

Thank you for any help.

--
Biostatistics & Data Management
Pharmacia & Upjohn - Milano - Italy Received on Wed Jul 28 1999 - 10:48:19 CDT