Does Oracle8i work?

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 identified by Oracle as 935119 with severity level 1. This should mean that Oracle development works on it until it's fixed. They
didn't tell us when this will be :(. At the moment we cannot use our system (NT 4.0 + Oracle8i + "java stored procedures") as production server.

Can someone try to verify if the problem arises on another platform?

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 Fri Jul 30 1999 - 07:13:52 CDT