ORA-00942 "APEX_190100"."WWV_FLOW_BLUEPRINT_REPO" Upgrading To APEX 19.X
(Doc ID 2553104.1)
Last updated on FEBRUARY 18, 2021
Applies to:
Oracle Application Express (APEX) - Version 19.1.0 and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
When trying to upgrade from APEX 18.x to APEX 19.x, the following errors occur:
Error log :
...
# Upgrade Metadata (1)
#
# Error: ORA-00942: table or view does not exist
# Statement: insert /*+append*/ into "APEX_190100"."WWV_FLOW_BLUEPRINT_REPO"
...
# Message: ORA-06550: line 6, column 17:
# PLS-00201: identifier 'WWV_FLOW_AUTHENTICATION_DEV.INTERNAL_MAKE_CURRENT'
must be declared
# ORA-06550: line 6, column 17:
# PL/SQL: Statement ignored
# Statement:
# declare
# l_old_sgid number := wwv_flow_security.g_security_group_id
;
# begin
# wwv_flow_security.g_security_group_id := 10;
# wwv_flow_authentication_dev.internal_make_current (
# p_scheme_identifier => 'APEX' );
# wwv_flow_security.g_security_group_id := l_old_sgid;
# end;
ok 351 - Enabling WS Constraints | 0.00
ok 352 - Dropping Upgrade Triggers in APEX_180200 | 0.02
not ok 2 - 337 actions passed, 15 actions failed | 1.35
begin
*
ERROR at line 1:
ORA-20001: Install errors found in phase 2
ORA-06512: at "APEX_190100.WWV_INSTALL_API", line 440
ORA-06512: at line 8
Changes
Upgrade to latest APEX available.
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 |