DG4MQ - Invalid Packages After Deployment Of pgmdeploy.sql version 19c
(Doc ID 2755724.1)
Last updated on FEBRUARY 25, 2021
Applies to:Oracle Database Gateway for WebSphere MQ - Version 220.127.116.11 and later
Information in this document applies to any platform.
Running the script pgmdeploy.sql in a 12.1 Oracle Database as part of the installation of the Oracle Database Gateway for MQ Version 19, the following happen:
When running the pgmdeploy script on an Oracle 12.1 database, getting below error -
ORA-06550: Row 3, Column 14:
PLS-00905: Object SYS.PGM is invalid
When running the pgmdeploy script on an Oracle 19c database, there is no invalid objects.
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