details: https://code.openbravo.com/erp/devel/pi/rev/2dd2efccfcc6 changeset: 28555:2dd2efccfcc6 user: Augusto Mauch <augusto.mauch <at> openbravo.com> date: Fri Jan 29 14:31:54 2016 +0100 summary: Fixes issue 32011: Trigger can be recreated with triggers to follow list (ORA)
Now it is possible to recreate an existing trigger, specifying a list of triggers of the same type that should be invoked before it. This development only affects Oracle database s, as in postgres the trigger execution order is given by the trigger's name. The Oracle8Builder has been updated to include a follows clause if the trigger being created must be executed before it. For instance, to create a trigger named TEST_TRIGGER_SECO ND that must be executed after a trigger called TEST_TRIGGER_FIRST, the builder constructs the following statement: CREATE TRIGGER TEST_TRIGGER_FIRST AFTER INSERT OR UPDATE ON TEST FOR EACH ROW FOLLOWS TEST_TRIGGER_SECOND DECLARE BEGIN END TEST_TRIGGER_FIRST ; diffstat: src-db/database/lib/dbsourcemanager.jar | 0 1 files changed, 0 insertions(+), 0 deletions(-) diffs (2 lines): diff -r b80096ac8943 -r 2dd2efccfcc6 src-db/database/lib/dbsourcemanager.jar Binary file src-db/database/lib/dbsourcemanager.jar has changed ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
