var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Dequeue BLOB from Ora AQ
Does anyone know how to dequeue a BLOB from a queue table using PL/SQL?
I keep getting the following error:
ORA-25236: buffer too small for user data
Here's my dequeue code:
set serveroutput on 1000000;
l_msg blob := empty_blob;
queue_name => 'JOOSTENBERGVLAKTE',
dequeue_options => l_options,
message_properties => l_properties,
payload => l_msg,
msgid => l_hnd
when others then
BLOB Requires LOB Locator
Your payload should be an aq.message type. Inside the type, you will have a lob locator. After extracting the lob locator, you will be able to populate the blob with dbms_lob.read.
Lobs are somewhat of a pain in AQ. I prefer XML or LCR formats although I relize those are not always appropriate.