Re: Help with DBMS_ALERT in oracle8.0.5 solaris x86

Hi,

   There is a problem with dbms_alert in oracle 8.0.5.0. Upgrade via patch to 8.0.5.2.1 and your example should work. I found this quirk: If you call signal( 'X' ) twice with the same 'X' and in the same transaction, the receiver only gets the last signal.

In article <7vk63p$k3$1_at_nnrp1.deja.com>,   hawk_at_octet.spb.ru wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 12 1999 - 11:00:14 CST