On 10/10/11 14:36, Adriano dos Santos Fernandes wrote: > On 10/10/2011 04:47, Dimitry Sibiryakov wrote: >> b) trigger body can be in Java. Firebird don't have both these problems. > Wrong reason, as Oracle doesn't support external triggers. > > You would just need to code a PL/SQL trigger that calls an external > procedure/function, so you would be able to use a IF anyway.
We should better not forget about conveniences of the end-user. Please agree, that code with WHEN + non-PL/SQL trigger looks better than dumb PL/SQL trigger + external function. ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel