Pgm_sup Does Not Handle "No More Messages" Condition
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
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
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
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