Ora-6502 While Trying To Put Multiple Messages On The MQ Queue In A Loop Using PG4MQ
(Doc ID 356912.1)
Last updated on FEBRUARY 06, 2019
Applies to:
Oracle Database Gateway for WebSphere MQ - Version 10.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
When trying to put multiple messages on a queue in a loop this fails
with an ORA-6502 error.
SQL> @putsample
Putting 50 messages on the queue
MQPUT: CorrelId length = 24
MQPUT: MsgId length = 24
MQPUT returned with reason code 0
MQPUT: CorrelId length = 24
MQPUT: MsgId length = 24
MQPUT returned with reason code 0
Error: Procedural Gateway for WebSphere MQ verification script failed.
ORA-06502: PL/SQL: numeric or value error: raw variable length too long
PL/SQL procedure successfully completed.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |