Re: Database callbacks.

In article <333D34A9.56D5_at_concentric.net>, rawoods_at_concentric.net says...
>
>Dan Shechter wrote:
>>
>> Back at where I work, we have a very strong need for callbacks
 (notices
>> sent to out applications upon insertaion to tables from the server).
>>
>> Those applications are running om remote systems from the oracle
 server,
>> which implies that some sort of network connection is required.
>>
>> What we've come up so far, was to use a trigger upon insertation on
 the
>> required tables, which will run a stored procedure, that will use the
>> PL/SQL UTL_FILE package which allows to write into operating system
>> files (or named pipes for that matter).
>>
>> Meanwhile, we have a small daemon, trying to read from those files.
>>
>> When the daemon succeeds in reading, it parses the data read, and
>> through TCP/IP inform the interested applications.
>>
>> Although this should work (OK, we haven't really tried it yet...),
>> I was wandering if anybody had ever met the same problem with a better
>> solution.
>>
>> Despratly awaiting.
>> Dan.
>Dan,
>
>You can use the DBMS ALERTS package to send e-mail too, although this
>asynchronous approach may not be what you need.
>--
>Rich Woods
>Technical Field Support Specialist, Oracle Corporation, USA
>The above statements and opinions are my own and do not
>necessarily represent those of Oracle Corporation.

You can use DBMS_PIPE package too to synchronously send a message to a deamon.

-- 
Laurent CITTON       (citton_at_shom.fr)
E.P.S.H.O.M          (www.shom.fr)
13 rue du Chatellier
BP 426
29275 BREST cedex
FRANCE