If the database server is a Windows server and you want to send to Windows
clients on a LAN / WAN how about something like the following
-- start here
-- netsend.sql
--
-- Send a message to all connected machines, using net send.
--
-- 20-Mar-2000 , Bruce Reardon : Creation.
--
--
set heading off
set pagesize 2000
-- this is it - remove listed domains & no duplicates & order by.
set def &
undef the_msg;
define the_msg = 'Hello';
select distinct
' rem user name : ' || username || ', os user: ' || osuser || chr(10)
|| 'net send ' || replace ( replace(machine,'DOMAIN1\') , 'DOMAIN2\' ) ||
' ' || '&the_msg'
from
( select username , osuser , machine from v$session where user# <> 0 order
by username )
;
undef the_msg;
-- end of netsend.sql
You could add a spool command, send the output to a batch file and then use
host command to run the batch file.
It could be improved to remove any generic domain by using substr and instr
but I haven't had the need to do that.
Is this the type of thing you are after?
Regards,
Bruce Reardon
-----Original Message-----
Sent: Tuesday, 4 December 2001 7:25
On NT LAN use the "NET SEND" command.
You can send to individual user names or domain wide
or to those that have connections to the server.
HTH
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
> -----Original Message-----
> From: Robert Chin [SMTP:[EMAIL PROTECTED]]
> Sent: Sunday, December 02, 2001 07:10 PM
>
> In our current environment, we have the need to be able to
> send LAN pop-up message to users of ACTIVE Oracle sessions.
> ("Pls log out NOW !...", "Pls don't do any x transactions..." etc you get
> the idea)
>
> If your organization have similar need.....
> Do you know how it's done in your organization ?
> Pls specify the infrastructure (whether it's via Internet or LAN and the
> OS)
>
> Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
