Re: DBMS_ALERT on NT 4.0

Check if user has explicit grants to execute packages dbms_alert, dbms_lock, dbms_pipe (both users, if receiving and sending sessions are running under different usernames).

In article <36CDCA53.679DEF17_at_online.no>,   Rune Wemberg <rwemberg_at_online.no> wrote:
>
> I have installed Oracle Enterprise v8.0.4.0.0 on a server running
> Windows NT 4.0
> Servicepack 3. I have run the catproc.sql and given the users the
> neccesary grants.
>
> I am trying to send an alert by typing execute
> dbms_alert.signal('MY_ALERT',null)
> on the sql prompt, but the client application never receives the
signal.
> I know
> the client application is working since I have run it on another NT
> machine
> and connecting to a database on a unix server. The server has the
same
> version of Oracle.
>
> What have I missed? Do I have to do anything special to get alerts
> working
> on Windows NT 4.0 vs on a Solaris server?
>
> Rune Wemberg
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 11 1999 - 20:33:52 CST