Pgm_sup Does Not Handle "No More Messages" Condition
(Doc ID 455537.1)
Last updated on JANUARY 11, 2023
Applies to:
Oracle Database Gateway for WebSphere MQ - Version 10.2.0.3 to 10.2.0.3 [Release 10.2]Information in this document applies to any platform.
Symptoms
No more messages exception message does not appear when a queue is empty.
MQ returns a -8501 but "No MORE Messages" is not thrown. Instead the default exception is thrown.
Looking at PGM_SUP the PRAGMA to handle "NO MORE MESSAGES" id commented out and hence this
condition will never be handled.
Current code which use to work in version 9 now fails in 10g.
The error condtion now passes a false condtion which results in the code
to fail.
Changes
Text message no longer handled by PL/SQL packages. They are not handled by external procs which uses cartridges. In addtion 2033 is now passed back instead of -8501
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 |
Changes |
Cause |
Solution |
References |