My Oracle Support Banner

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 12.1.0.2 and later
Information in this document applies to any platform.

Goal

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.


Solution

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
Goal
Solution


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