Oracle AQ notification

Hi, this is regarding oracle aq.

Suppose the oracle AQ is a asychronous messaging technology, how ever, i dont understand how to set up this:

1)if a new record is inserted into table 'student', how to setup so that the oracle will enqueue the new record into queue?

2)if the is a new object in queue, how to setup a notification mechanism so that the oracle will send the notification to the target?

This is urgent for me. Any guideline will be appreciated!


Thanks in advance.

Use Google -> URL and URL2 (ppt)
but why Oracle AQ? Just use JMS

hi, thanks for ur information.

my client's database is Oracle 9i, so i use AQ and AQ can utilize the RAC (Real Application Cluster).

another question that i need to know is:
do i need a j2ee server to run jms client?

if i use Sun ONE server, how do i configure the JMS configuration in Sun ONE, so that it can connect to AQ?


thanks

Ok, i managed to create queue, and perform enqueue/dequeue operation.

now, there r two databases: HR and warehouse. The enqueue operation in HR db while the dequeue operation in warehouse db.

i have register the notification using DBMS_AQ.register the dequeue operation (a stored procedure) to receive notification.

however, the dequeue operation is not called when there is a new message in queue.

what do i need to check? do i need to add schedule for the notification?

thanks!