Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

callback notification

3351May 21 2003

Hi All

How to register pl/sql notification using DBMS_AQ.register to a queue over a dblink. My subscribers are queues on a different db whom we communicate via dblinks.
How do i create callbacks to notify my subscriber queues over dblinks. i tried to apend the dblink name to the reginfo list but to no vail. the procedure for plsql callback notification doesnt compile at all gives the error
ORA-25255: incorrect subscription string aquser.client_queue@testdb.us.oracle.com.

Suppose notifcation is set & the subscriber database is down what could be the repercussions of this scenario.

Will notification be re triggered once the subscriber queue db is up & running so that it can continue with dequeueing.

Kindly respond

Regards
Sushant

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 18 2003

Added on May 21 2003

#advanced-queueing, #database-key-features

0 comments

439 views