Example for Starting an Oracle Alerter

To start an alerter on an Oracle database, you have to run the commit_and_notify_table stored procedure.

The following example shows how to run the stored procedure on an Oracle database. It is assumed that the rvpub.tra configuration has its data source name, user account name (demo) and password defined in the repository.

Prerequisites

A Publication Service service with the TIBCO Rendezvous transport type has been configured with the alerter method selected.

Procedure

Start the adapter configuration by typing the following command:
adbagent --propFile rvpub.tra
Insert a message and then run the commit_and_notify_table stored procedure with the publishing table monitored by the adapter.
For example, if the adapter is monitoring the PUB_ORDER table, run the stored procedure as follows:
```
sqlplus demo/demo
insert into ORDER_TABLE values(111,'Oak Table',499.95);
SQL> call commit_and_notify_table (’PUB_ORDER’);
```
The procedure puts a message on Oracle AQ. The publisher endpoint then reads its publishing table and sends a message containing the changed data on its configured subject.

Result

This example shows how to notify an adapter configuration to poll a single table, that is, PUB_ORDER, for changes. You can use the commit_and_notify stored procedure to poll all publishing tables for changes.