Re: DBMS_ALERT won't work

From: Johan Wegener <xjwegener_at_xpost.xtele.xdk>
Date: Mon, 26 Jul 1999 10:50:09 +0200
Message-ID: <7nh7bt$a80$1@news.inet.tele.dk>

juergen_benkel_at_my-deja.com wrote in message = <7nh24h$v1n$1_at_nnrp1.deja.com>...
>Hello,
>I have moved from a Oracle 8.0.3 to a 8.0.5 Database.
>My application uses DBMS_ALERT and it worked fine in the 8.0.3.
>Now in the 8.0.5, the behavior of the WAITANY call has changed
>dramatically:
>The WAITANY won't wake up, when the registered signal is sent, it will
>be recognized the next time WAITANY is called.
>Could anybody help me?
>
>I have rerun the DBMSALERT.sql and PRVTALRT.PLB script to ensure the
>package is installed correct.
>Any suggestions?

Unfortunately you are not indicating which OS you are using. If it is NT = you should get a patch upgrade to Oracle 8.0.5.1.3. I've had some = DBMS_ALERT related bugs that became fixed in that version.

Cheers,
Johan Received on Mon Jul 26 1999 - 03:50:09 CDT