My Oracle Support Banner

DATAPATCH ON 18C FAILS WITH ERROR "PLS-00302: COMPONENT 'ADD_JOB_EMAIL_NOTIFICATION_PH3' MUST BE DECLARED" (Doc ID 2544581.1)

Last updated on JULY 01, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 18.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

When running datapatch on 18c for RU/RUR patch, it reports following error for object 'dbms_scheduler' - while executing prvtbsch.plb on the PDB

Patch 28822587 apply (pdb TESTPDB1): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/28822587/22600665/28822587_apply_TEST_TESTPDB1_2019Mar04_13_01_25.log (errors)
Error at line 26451: 4498/3 PL/SQL: Statement ignored
Error at line 26452: 4498/3 PLS-00306: wrong number or types of arguments in call to
Error at line 26455: 4532/3 PL/SQL: Statement ignored
Error at line 26456: 4532/19 PLS-00302: component 'ADD_JOB_EMAIL_NOTIFICATION_PH3' must be

 

Changes

 Applied 18c RU/RUR

Cause

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
Symptoms
Changes
Cause
Solution


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