Post Install Patch Script Generates "SP2-0810: Package Body created with compilation warnings" (Doc ID 749329.1)

Last updated on MARCH 12, 2019

Applies to:

Symptoms

-- Problem Statement:
When performing post-installation patch actions (using any patch set or patch including Critical Patch Updates) if the parameter plsql_warnings is set to any  value other then default, the post-installation SQL scripts can fail with "SP2-0810: Package Body created with compilation warnings".

-- Other Examples of errors / warnings that can be raised by this issue:

create or replace package body DBMS_ASSERT wrapped
SP2-0810: Package Body created with compilation warnings

CREATE OR REPLACE FUNCTION version_script
SP2-0806: Function created with compilation warnings

SP2-0817: Type altered with compilation warnings

create or replace package dbms_standard is
SP2-0808: Package created with compilation warnings

CREATE OR REPLACE PACKAGE BODY dbms_registry
SP2-0810: Package Body created with compilation warnings

CREATE OR REPLACE PACKAGE utl_raw IS
SP2-0808: Package created with compilation warnings

SP2-0804: Procedure created with compilation warnings

SP2-0818: Type Body created with compilation warnings

SP2-0816: Type created with compilation warnings

-- Steps To Reproduce:
Set alter system set plsql_warnings='ENABLE:ALL'

-- Business Impact:
Slows down patching process, can corrupt DBMS_STANDARD.

Cause

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