Re: Call c-function within trigger

From: Karsten Spang <krs_at_kampsax.dk>
Date: 1995/10/14
Message-ID: <45opc5$kq6_at_stamlink.kampsax.dk>#1/1


In article <45cb87$lku_at_gw.PacBell.COM>, rpatel_at_solutech.com writes:
|> Only way I now of doing this is to use DBMS_PIPES and have another process
|> listening for messages on the pipe. This way, within the trigger, you can
|> send a message across the pipe and a process outside of Oracle can be polling
|> the pipe for messages. Oracle support has a bulletin on this topic.

There is a simplied interface called DBMS_ALERT. Check the file dmbsalert.sql. There is also a bulletin about this.

-- 
Karsten Spang                                    Snail Mail:  Kampsax Data
E-mail: krs_at_kampsax.dk                           P.O. Box 1142
Phone:  +45 36 39 07 88                          DK-2650 Hvidovre
Fax:    +45 36 77 03 01                          Denmark
Received on Sat Oct 14 1995 - 00:00:00 CET

Original text of this message