Forum Stats

  • 3,853,405 Users
  • 2,264,217 Discussions
  • 7,905,340 Comments

Discussions

Datapatch of 12.2.0.1 fails with PLS-00201

When trying solution from https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=186230747364622&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&…

datapatch 31312468/23691856 fails with the following:

'Warning: Package Body created with compilation errors.',

      'Warning: Package Body created with compilation errors.',

      '4675/4   PL/SQL: Statement ignored',

      '4675/23  PLS-00302: component \'ISNONORACLECLOUD\' must be declared',

      '4675/4   PL/SQL: Statement ignored',

      '4675/23  PLS-00302: component \'ISNONORACLECLOUD\' must be declared',

      'Warning: Trigger created with compilation errors.',

      '0/0      PLS-00905: object GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN is invalid',

      'Warning: Trigger created with compilation errors.',

      '0/0      PLS-00905: object GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN is invalid',

      'Warning: Trigger created with compilation errors.',

      '0/0      PLS-00905: object GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN is invalid'

any ideas how to solve this?