Oracle Service Bus, publish small/big messages to Oracle AQ endpoint

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).

queue_table_select

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.

Advertisements

About Eric Elzinga
Eric Elzinga I'm an integration consultant located in The Netherlands. Mainly doing projects based on Oracle integration stacks (Oracle SOA Suite/Oracle Service Bus (OSB)), Java development, and opensource integration products.

3 Responses to Oracle Service Bus, publish small/big messages to Oracle AQ endpoint

  1. Edwin Biemond says:

    Hi,

    watch out , because oracle desides where to put the payload , you could have some problems with plsql to get the message.

  2. Eric Elzinga says:

    Didn’t do a test yet..but guess you can use the text_len to decide to either select on the lob or text value.

  3. Pingback: Oracle Service Bus, publish small/big messages to Oracle AQ endpoint | Oracle .. Java .. OpenSource .. SOA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: