DBMS_AQ

From: roy <roy.schultheiss_at_t-online.de>
Date: 10 May 2006 01:12:55 -0700
Message-ID: <1147248774.940444.257030@i39g2000cwa.googlegroups.com>

dears.

i have a procedure in my ora-db that permanently dequeus messages from an oracle-queue.
like:

dequeue_options.navigation := DBMS_AQ.first_message; LOOP

                DBMS_AQ.dequeue (queue_name               =>
'PRESEL_REQ',
                                 dequeue_options          =>
dequeue_options,
                                 message_properties       =>
message_properties,
                                 payload                  => payload,
                                 msgid                    => msgid
                                );
               dequeue_options.navigation := DBMS_AQ.next_message;

END LOOP; what options du i have to handle this procedure - means how to start and how to stop?
for the moment i start this procedure by calling it in an oracle job und stop it with kill -9 <spid>.

is there a better way to do this?

best regards,

roy Received on Wed May 10 2006 - 03:12:55 CDT