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 to [Release 10.2]
Information in this document applies to any platform.


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.


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


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

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