Alerter

The alerter method is used to asynchronously notify Publication Service of database changes. The adapter does not poll its publishing table for new rows at every interval. you can use the alerter method only when database changes are infrequent.

Procedures can be executed on the SQL command line or through any supported Application Programming Interfaces (the procedures cannot be invoked successfully from within a trigger). The procedures commit the inserts into the database table and notify the adapter of the commit.

Because an alerter runs with a database instance, not user schema, an adapter configuration cannot poll the publishing table name for just one user schema. For example, if the same publishing table exists for two user schemas and two adapter configurations are monitoring the same publishing table, each adapter configuration with a different user, both adapter configurations check the same publishing table whenever the alerter checks for changes in the publishing table.