My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.