Re: How to send message to all oracle sessions

I think you can use DBMS_PIPE, i saw that in RDBMS Oracle7 Server Application Developer's Guide (.PDF with Acrobat Reader). I've never use it and I tried something else on NT 3.51. It seems OK with SQL+, you can try it.

NetSend.SQL file :

SET LINES 300
SET PAGES 0
SET HEADING OFF
SET FEED OFF
SET VERIFY OFF ACCEPT msgtxt PROMPT 'Message text : '

SPOOL C:\netsend.cmd

SELECT 'NET SEND '||machine||' '||'&msgtxt' COMMAND FROM v$session
WHERE machine IS NOT NULL
AND machine <> 'server name';

SPOOL OFF HOST CALL C:\netsend.cmd
HOST DEL C:\netsend.cmd

The maximum length of the message is 240 (max of ACCEPT), use LINESIZE 300 for command + message
machine <> 'server name' Don't send the message to the database server

abray_at_club-internet.fr

faisal_qasim_at_writeme.com a écrit dans l'article <7dceuc$i1e$1_at_nnrp1.dejanews.com>...
> Dear all,
>
> I wish to send message to all Oracle connections (sqlnet connections).
How can
> it be achieved? Messages are needed, for e.g. for emergency servicing,
etc.
>
>
> Regards
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

>
Received on Sun Mar 28 1999 - 15:35:03 CST