Forum Stats

  • 3,836,970 Users
  • 2,262,210 Discussions


OCI client notification without a AQ queue

642407 Member Posts: 1
edited Dec 17, 2008 9:59PM in Oracle Call Interface (OCI)
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


This discussion has been closed.