ORA-38824 for trigger FLOWS_FILES.wwv_biu_flow_file_objects, Upgrading APEX 19.1 from 5.1 on a 12.2 DB
(Doc ID 2532498.1)
Last updated on OCTOBER 02, 2023
Applies to:Oracle Application Express (APEX) - Version 19.1.0.00.15 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
On : APEX 19.1.0.00.15 version,
When attempting to upgrade APEX from 5.1 to 19.1 on a 12.2 DB
the following error occurs.
create or replace trigger FLOWS_FILES.wwv_biu_flow_file_objects
ERROR at line 1:
ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property
of an existing object.
The issue can be reproduced at will with the following steps:
1. Upgrade a Healthy APEX 5.1.1 on a 12.2 DB to APEX19.1
2. The install fail and left APEX invalid in dba_registry
When running in this environment, the customer may notice that they are not able to import a plug-in export.
1. Select the file for import.
2. Click next. The file appears to be selected, however the user sees a failure "File must be selected to upload".
Upgrading to APEX 19.1
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