My Oracle Support Banner

Package Body APEX_050000.WWV_FLOW_SPATIAL_INT is invalid and can not be recompiled (Doc ID 2163018.1)

Last updated on SEPTEMBER 10, 2021

Applies to:

Oracle Application Express (APEX) - Version 5.0.1 and later
Oracle Database Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

The WWV_FLOW_SPATIAL_INT is invalid and can not be recompiled. When recompiling the package body the following errors are seen:

alter package APEX_050000.WWV_FLOW_SPATIAL_INT compile body;

Warning: Package Body altered with compilation errors.

>>>show err;
Errors for PACKAGE BODY APEX_050000.WWV_FLOW_SPATIAL_INT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
134/13 PL/SQL: SQL Statement ignored
134/31 PL/SQL: ORA-01031: insufficient privileges
207/9 PL/SQL: SQL Statement ignored
207/27 PL/SQL: ORA-01031: insufficient privileges
212/9 PL/SQL: SQL Statement ignored
212/27 PL/SQL: ORA-01031: insufficient privileges
261/9 PL/SQL: SQL Statement ignored
261/27 PL/SQL: ORA-01031: insufficient privileges

 

Changes

Dropped existing MDSYS user from the database.
Recreated MDSYS as per note: <Note 220481.1> - Primary Note for Oracle Spatial and Oracle Locator Installation.

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
References


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