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

Last updated on JUNE 27, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 5.0.1 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> - Master Note for Oracle Spatial and Oracle Locator Installation.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms