Re: Trigger on shared tables

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Fri, 22 Aug 2003 23:19:24 GMT
Message-ID: <0yx1b.1394$vy5.634@nwrddc01.gnilink.net>

"Stefan Rupp" <st.rupp_at_t-online.de> wrote in message news:bi604f$dsr$03$1_at_news.t-online.com...
> Good evening,
>
> Anurag Varma schrieb:
> > .. additing to this. If the inserts/updates are that frequent, why not
just
> > call the C++ function via the trigger? You can do that also.
>
> How do I do that? Pardon me for my poor understanding of Oracle
> mechanisms, I have only used it as a storage manager so far.
>
> How do I call a C or C++ function from within an Oracle trigger?
>
> Regards,
> Stefan
>

Stefan,

Also remember: If you call an external procedure via a trigger .. and if the original transaction fails -
Then whatever you do in that external procedure will not be rolled back. Be aware of that!

This problem will be there in the dbms_alert also.

Since I do not recall doing a transaction using an external procedure, I do not know of the pitfalls of
using this method. Test Test Test...

You can probably trigger a polling to be done using the trigger (i.e. send an async signal to the external procedure to poll the actual table .. and make that trigger to be after insert and statement level trigger)

Anurag

Anurag Received on Fri Aug 22 2003 - 18:19:24 CDT