Re: Broadcast message to oracle users
Date: 1996/02/04
Message-ID: <odysscci.576.000C6340_at_teleport.com>#1/1
In article <4etp1i$au1_at_nm3001.router.kraft.com> Roger Harris <rharris_at_kraft.com> writes:
>Path: nntp.teleport.com!news.structured.net!news.cais.net!news.sprintlink.net!newsfeed.internetmci.com!gatech!newsjunkie.ans.net!news.kraft.com!usenet
>From: Roger Harris <rharris_at_kraft.com>
>Newsgroups: comp.databases.oracle
>Subject: Re: Broadcast message to oracle users
>Date: 2 Feb 1996 19:35:14 GMT
>Organization: Kraft Foods
>Lines: 29
>Message-ID: <4etp1i$au1_at_nm3001.router.kraft.com>
>References: <4et7i5$6qo_at_explorer.csc.com>
>NNTP-Posting-Host: 192.97.131.58
>Mime-Version: 1.0
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>X-Mailer: Mozilla 1.22 (Windows; I; 32bit)
>dmarsha3_at_csc.com (dmarsha3) wrote:
>>Group:
>>
>>Is there any facility in Oracle 7 which allows to broadcast a message
>>to the oracle users logged on to the machine. Especially when I wan't to
>>shutdown the database I would like to send message to the users rather than
>>doing a "shutdown immediate" . I would appreciate if somebody has any
>>ideas on this.
>>
>I think that would depend on the client program you were using. If your
>clients were running Oracle Forms or PowerBuilder, you might be able to
>write a routine that the client executed every several minutes (via a timer)
>to check for some type of message in an Oracle table. The program could
>then display the message. I don't believe there is any way the Oracle
>server can notify the clients by itself. And once the server is down, any
>client SQL processing will fail with some nasty message.
>If you are running client apps on the same system (like SQL*Forms), use your
>O/S facility to send a message to all users.
>--
>Roger Harris
>DBA
>Kraft Foods
>White Plains, NY
You could use an oracle alert and have each client register for that alert when they login. You have to open another connection to do so. Otherwise the suggestion above will work just fine.
Jim Kennedy Received on Sun Feb 04 1996 - 00:00:00 CET