OCI client notification without a AQ queue

642407

Hi Forum,

Well, put it in the simplest manner, I want to run a perl script when a Insert trigger occurs.

And I was wondering if it is possible that a OCI client be notified, when a trigger occurs, without using a AQ queue ?
I ask that because in Oracle Manuals we can find this:

An OCI application can:

* register interest in notifications in the AQ namespace and be notified when an enqueue occurs.
* register interest in subscriptions to database events and receive notifications when the events are triggered.
* manage registrations, such as disabling registrations temporarily or dropping the registrations entirely.
* post, or send, notifications to registered clients.

Hoping to hear from you soon, forum.

Pedro Campos Galvão

Edited by: user639404 on 20/Nov/2008 16:01

560199

yes, you can.

follow the oracle documentation:

Oracle Call Interface Programmer's Guide -
9. OCI Programming Advanced Topics :: Database Change Notification.