Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid FLOWS_FILES.WWV_BIU_FLOW_FILE_OBJECTS after upgrading from 5.1.3 to 18.2

zagirovOct 20 2018 — edited Oct 22 2018

#

# Installing FLOWS_FILES Objects

#

PL/SQL procedure successfully completed.

...create flows_files

...trigger wwv_biu_flow_file_objects

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.

No errors.

in the end I get. How to treat it?

...(11:21:34) Starting validate_apex for APEX_180200

...(11:21:49) Checking missing sys privileges

...(11:21:49) Re-generating APEX_180200.wwv_flow_db_version

... wwv_flow_db_version is up to date

...(11:21:50) alter package sys."WWV_FLOW_VAL" compile body

...(11:21:50) Checking for objects that are still invalid

...(11:21:51) Recompiling FLOWS_FILES ... with dbms_utility.compile_schema

...(11:22:03) Checking for objects that are still invalid

ORA-20001: COMPILE FAILURE: TRIGGER FLOWS_FILES.WWV_BIU_FLOW_FILE_OBJECTS

...5/9      PLS-00201: identifier 'WWV_FLOW_FILE_OBJECT_ID.G_ID' must be declared

...5/9      PL/SQL: Statement ignored

...11/9     PLS-00201: identifier 'WWV_FLOW_FILE_OBJECT_ID.G_ID' must be declared

...11/9     PL/SQL: Statement ignored

...(11:22:03) Key object existence check

ORA-20001: FAILED status check for FLOWS_FILES.WWV_BIU_FLOW_FILE_OBJECTS: INVALID

...(11:22:13) Setting DBMS registry for APEX to INVALID

...(11:22:13) Exiting validate_apex

PL/SQL procedure successfully completed.

Comments
Post Details
Added on Oct 20 2018
8 comments
5,097 views