Error at PACKAGE BODY WWV_FLOW_SPATIAL_INT When Installing or Upgrading APEX
(Doc ID 2792185.1)
Last updated on AUGUST 30, 2023
Applies to:
Oracle Application Express (APEX) - Version 20.1 and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Spatial and Graph - Version 19.18.0.0.0 to 19.18.0.0.0 [Release 12.2]
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
Changes
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 |
| 1.- Validate Spatial |
| 2.- Remove / Uninstall Spatial |
| References |