Java Dequeue msg with >32kb RAW payload not possible error ORA-25236
499821Mar 20 2006 — edited Mar 23 2006We try to read a message with more then 32k RAW payload in a multiconsumer queue but we get the error ORA-25236. We use oracle.AQ to dequeue.
The limit for the called funtion in DBMS_AQIN is for PL/SQL 32kb. We try also to use OCI but for the dequeing the driver switch also to the DBMS_AQIN function in this package.
I need an running example within Java to dequeue more the 32kb RAW payload data. It is not important how we do this (maybe JMS, OCCI, PL/SQL) necessary is that we can do this.