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!
10-10-2000, 02:19 AM
how about DBMS_PIPE?
10-10-2000, 06:30 AM
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.
10-10-2000, 05:00 PM
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.