Re: dbms_pipes from trigger

From: David <darussell_at_msn.com>
Date: Sat, 11 Apr 1998 20:45:53 +0100
Message-ID: <u4SJ8JYZ9GA.205@uppubnews03>

A far more eligant solution would be to use Oracle 8 external procedures, they will allow you to do all that you have listed.

Regards
David Russell

Timo Feickert wrote in message <892135735.548900_at_services>...
>hello world,
>
>i would like to do some "homegrown" data replication.
>i imagine an external process call via dbms_pipes from
>within a "before trigger".
>
>the external process would signal back to the trigger,
>whether the data-replication (or any other external task)
>was successful. If not, the trigger issues a raise_app_error
>to let the whole transaction fail.
>
>what do you think - should work or let's forget about it ???
>
>tyia!
>
>--
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Timo.Feickert_at_prompt.de.NOWHERE
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>(please remove trailing [.NOWHERE])
>
>
>
Received on Sat Apr 11 1998 - 14:45:53 CDT