My Oracle Support Banner

Error at PACKAGE BODY WWV_FLOW_SPATIAL_INT When Installing or Upgrading APEX (Doc ID 2792185.1)

Last updated on JULY 15, 2021

Applies to:

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

Symptoms

On: APEX 20.1 or higher version, Administration

When attempting to install or upgrade APEX, the following error occurs.

ERROR
-----------------------
#
# Actions in Phase 2:
#
ok 1 - BEGIN | 0.00
not ok 2 - Upgrade Metadata (1) | 0.00
# Message: PL/SQL: Statement ignored
# Statement: PACKAGE BODY APEX_200100.WWV_FLOW_SPATIAL_INT, Line 127/13
# Message: PLS-00302: component 'INSERT_ALL_SDO_GEOM_METADATA' must be declared
# Statement: PACKAGE BODY APEX_200100.WWV_FLOW_SPATIAL_INT, Line 127/28
ok 3 - Upgrade Metadata (2) | 0.00
not ok 4 - Recompiling APEX_200100 schema | 0.02
# Message: PL/SQL: Statement ignored
# Statement: PACKAGE BODY APEX_200100.WWV_FLOW_SPATIAL_INT, Line 127/13
# Message: PLS-00302: component 'INSERT_ALL_SDO_GEOM_METADATA' must be declared
# Statement: PACKAGE BODY APEX_200100.WWV_FLOW_SPATIAL_INT, Line 127/28


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Start SQL Plus as SYS
2. Run APEX installation script
3. Error can be viewed on the installation log


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
 1.- Validate Spatial
 2.- Remove / Uninstall Spatial
References


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