Pgm_sup Does Not Handle "No More Messages" Condition (Doc ID 455537.1)

Last updated on AUGUST 23, 2010

Applies to:

Oracle Database Gateway for WebSphere MQ - Version: 10.2.0.3 to 10.2.0.3 - Release: 10.2 to 10.2
Information in this document applies to any platform.
Checked for relevance 23-Aug-2010

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms