we have to do asynchronious database job: One process puts messages
in a queue and other processes get the msgs and do the real work.
I think the dmbs_aq package is great for doing things with queues (maybe thats why the packages is named "advance queuing" :-)).
But how to I start "jobs" in the meaning of processes that just wait for an signal/msg to execute? With dbms_jobs? Or with triggers? What is the standard way to do it?
Thank you in advance!
The package DBMS_AQADM is an interface to the administrative tasks of Advanced Queuing, such as creating/dropping queues and queue tables.
The package DBMS_AQ offers accesss to the enqueue en dequeue operations.
Yes, using DBMS_PIPE is one of the method.
U can write a package which include some procedures or
functions that can be used all the time.
By using DBMS_PIPE does impact the performance, so use it