Re: Can a trigger pass a message to sockets

tom wrote:
:> We're running Oracle 7.1.6 on Solaris 2.4 and are trying to implement
:> a simple messaging system.
:> Is it possible for a trigger to pass a message outside of
:> Oracle (ie, via sockets)???

Our application uses database trigers to send changes to a VAX to maintain a flat file system until we get the application ported into Oracle. Messages placed in the pipe control the daemon

        (close socket, pause, open socket, scan the table...)

Create a socket daemon which does an Oracle dbms_pipe read. The daemon will sleep until a message arrives in the dbms_pipe.

We put the messages in a temp table for the daemon to send and use the pipe to wake up the daemon. A message is placed in the pipe by a procedure so that only one message is in the pipe at a time. This prevents the pipe from filling up while the daemon is processing the the table.

The daemon scans the table until it is empty and returns to the dbms_pipe read to sleep.

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.