Re: DBMS_ALERT...Has anyone successfully used these functions on NT?

Robert Alan Whitaker, Jr. <whitaker_at_netnitco.net> skrev i en nyhedsmeddelelse:7o5vo5$hn3$1_at_hyperion.nitco.com...
> I have been attempting to use Oracle Alerts (DBMS_ALERT.REGISTER,
.WAITONE,
> and .SIGNAL) using Oracle 8.0.5.0.0 for Windows NT, but have not had much
> luck.
>
> I was able to successfully use these functions on an Alpha machine
> (OpenVMS), running version 7.3.?.?.?, and they all worked as expected, but
I
> have had little success with them on the NT version mentioned above. At
> first, I was not getting ANY response whatsoever, then, after checking on
> Oracle's online help, a patch was found (patch set 8051), which sounded as
> though it may fix the problem, and, sure enough, after installing the 49MB
> patch on a client machine, I was able to get the alerts to function, but
not
> ALL the time. On occasion, the .WaitOne call would time out, even though
I
> had used the .Signal command and commited from another instance. The
> .Signal was seemingly not seen. Then, if I submitted the .WaitOne request
> again (and commited), it would return immediately, with the message
provided
> in the .Signal. Why doesn't it return in the original call?
>
> Second problem:
> So, next, I decided to install this same patch to the server machine,
> and now the Alerts act even more sporadically, if at all. Has anyone else
> had this experience? Any comments or suggestions?
>

Oh yes, I recognize these symptoms. After patching Oracle to 8.0.5.1.3 (a level above what you've got I gather) everything worked to my satisfaction.

Cheers,
Johan Received on Tue Aug 03 1999 - 02:34:11 CDT