by 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:Quote:}
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