Help with DBMS_ALERT in oracle8.0.5 solaris x86

Hello.

I've an application using dbms_alert package in oracle7.3.2, after migrating to oracle-8.0.5 EE Solaris x86 edition, Dedicated server, the package failed to work properly. I'm using this code for test:

$ cat signal.sql

begin
dbms_alert.signal('qqq','aaaaaaaaaaaaa'); commit;
end;

$cat wait.sql

declare
mesg varchar2(500);
status number;
begin
dbms_alert.register('qqq');
dbms_alert.waitone('qqq',mesg,status);
if (status=0) then

    raise_application_error(-20000,'It''s all right');   else
    raise_application_error(-20000,'Something is wrong');   end if;
end;

I run wait.sql, and then signal.sql, but first session continues to wait for alert. After stoping it with ^C, and running again, it suddenly finishes with succesive alert message, but that's behavior is much different from oracle7.3.2.

What's wrong with my settings?
If this a bug, can You tell my patch or bug number.

Sincerely yours
Dmitry Khrissanov

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 01 1999 - 07:55:06 CST