Oracle Service Bus, publish small/big messages to Oracle AQ endpoint
August 12, 2009 3 Comments
The weird thing was for certain responses i couldn’t find the payload back when i queried the aq table in the database.
select qt.user_data.text_vc , qt.user_data.text_lob from my_aq_table qt
The process just completed succesfull in osb, but the payload wasn’t there (well it looked like it wasn’t there).
When publishing big payloads to an Oracle AQ endpoint, Oracle (db) will decide weither the payload will get stored either as text-value or clob-value.
Messages smaller then 4k will get inserted as text, messages bigger then 4k will get inserted as clob.