Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Writing to Oracle aq failing for messages more than 4000 bytes...

user12968689Apr 2 2014 — edited Apr 4 2014

Trying to write to an Oracle aq from camel. Messages more than 4000 bytes are failing, where as smaller messages are passing through fine.

Looks like OracleAQ jar is not properly converting the textmessage to CLOB as the size of the message is more than 4000 bytes and instead passing it as VARCHAR.

The error that i get for when trying to send messages bigger than 4000 bytes is :

oracle.jms.AQjmsException: ORA-00942: table or view does not exist

Any ideas

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2014
Added on Apr 2 2014
1 comment
1,200 views