Message.text_vc Changes To Message.text_lob In AQ On Dequeue
(Doc ID 2787677.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Here enqueue is done using JBOSS fuse application with JDBC 8.
Dequeuing as below using PL/SQL:-
DBMS_AQ.DEQUEUE(queue_name => '<QUEUE_NAME>',
dequeue_options => dequeue_options,
message_properties => message_properties,
payload => message,
msgid => message_handle);
On checking don't find message in message.text_vc which was enqueued.
But message is changed to message.text_lob.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document