How should I use the alerter if my desired event sequence is Source table inserted with data - table trigger - [my stored procedure] - commit_and_notify (or similar) - alerter is notified - agent then publishes?

How should I use the alerter if my desired event sequence is Source table inserted with data - table trigger - [my stored procedure] - commit_and_notify (or similar) - alerter is notified - agent then publishes?

book

Article ID: KB0084478

calendar_today

Updated On: 01-14-2017

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

Resolution:
The general recommendation is: place commit_and_notify wherever you would place commit in your stored procedure. If your stored procedure does commit itself, then you only need to do “notify” part of commit_and_notify. Here are the steps:

1) Remove "commit work" line from "commit_and_notify" stored procedure.
2) Add "execute commit_and_notify" to your stored procedure.

Issue/Introduction

How should I use the alerter if my desired event sequence is Source table inserted with data - table trigger - [my stored procedure] - commit_and_notify (or similar) - alerter is notified - agent then publishes?

Environment

Product: TIBCO Adapter for ActiveDatabase Version: ALL OS: All --------------------

Attachments

How should I use the alerter if my desired event sequence is Source table inserted with data - table trigger - [my stored procedure] - commit_and_notify (or similar) - alerter is notified - agent then publishes? get_app