|
|
|
dequeue buffered massage
|
|||
|---|---|---|---|
|
#18+
Доброго времени суток. Подскажите, почему не получается извлечь буферизированное сообщение из очереди? Вроде, все правильно. Вот код: declare S UserType := new UserType(); l_msg_props dbms_aq.message_properties_t; l_dequeue_opts dbms_aq.dequeue_options_t; l_enqueue_opts dbms_aq.enqueue_options_t; l_msg_id raw(16); rcpt_list dbms_aq.aq$_recipient_list_t; l_queue_name varchar2(38) := 'USERTYPES_QUEUE'; begin dbms_aqadm.add_subscriber(queue_name => l_queue_name, subscriber => sys.aq$_agent('SUBSCRIBER', null, null), rule => '', transformation => '', queue_to_queue => false, delivery_mode => dbms_aqadm.PERSISTENT_OR_BUFFERED); l_enqueue_opts.delivery_mode := DBMS_AQ.BUFFERED; l_enqueue_opts.visibility := DBMS_AQ.IMMEDIATE; rcpt_list(1) := sys.aq$_agent('SUBSCRIBER', null, null); l_msg_props.recipient_list := rcpt_list; dbms_aq.enqueue(queue_name => l_queue_name, enqueue_options => l_enqueue_opts, message_properties => l_msg_props, payload => S, msgid => l_msg_id); l_dequeue_opts.consumer_name := 'SUBSCRIBER'; l_dequeue_opts.visibility := DBMS_AQ.IMMEDIATE; l_dequeue_opts.NAVIGATION := DBMS_AQ.FIRST_MESSAGE; dbms_aq.dequeue(l_queue_name, l_dequeue_opts, l_msg_props, S, l_msg_id); -- зависает в ожидании end; ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 08.01.2019, 18:02 |
|
||
|
|

start [/forum/topic.php?fid=52&fpage=88&tid=1882961]: |
0ms |
get settings: |
7ms |
get forum list: |
15ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
25ms |
get topic data: |
9ms |
get forum data: |
3ms |
get page messages: |
30ms |
get tp. blocked users: |
2ms |
| others: | 224ms |
| total: | 321ms |

| 0 / 0 |
