Package Body APEX_050000.WWV_FLOW_SPATIAL_INT is invalid and can not be recompiled
(Doc ID 2163018.1)
Last updated on JUNE 16, 2023
Applies to:
Oracle Application Express (APEX) - Version 5.0.1 and laterOracle 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 |