My Oracle Support Banner

Datapatch with error PLS-00302: component 'SESSION_ENABLED_ROLE_VARCHAR' must be declared (Doc ID 2728463.1)

Last updated on DECEMBER 24, 2020

Applies to:

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

Symptoms

datapatch fail with error :

Patch 31001106 apply: WITH ERRORS
  logfile: ...../cfgtoollogs/sqlpatch/31001106/23710733/31001106_apply_2020Oct31_19_24_27.log (errors)
  Error at line 26939: Warning: Package Body created with compilation errors.
  Error at line 26946: 3412/5 PL/SQL: Statement ignored
  Error at line 26947: 3413/26 PLS-00302: component 'SESSION_ENABLED_ROLE_VARCHAR' must be

 

patch apply logfile has below error :

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
Cause
Solution
References


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