Problem with the DBMS_ALERT package in Solaris v. Windows

From: Douglas Whitacre <whitacre_at_imake.com>
Date: Wed, 7 Apr 1999 14:16:56 -0400
Message-ID: <7eg7fj$5qj@world1.bellatlantic.net>

If anyone can help with the following problem that would be great:

If I have one SQL+ window and run DBMS_ALERT.REGISTER to register a signal name and commit, then run DBMS_ALERT.WAITONE to wait for the signal, the command blocks. Running DBMS_ALERT.SIGNAL with the signal name and committing in another window should cause the first window's WAITONE command to return. It works fine if the oracle server is 8.0.5.0.0 for Solaris, but if the server is 8.0.4.0.0 for Windows NT, the WAITONE function never returns.

Thanks in advance Received on Wed Apr 07 1999 - 13:16:56 CDT