Hi ,
I am using Apex 20.1 , Oracle19C. I exported applications using the java oracle.apex.APEXExport utility in order to migrate apps to another server.
I ran the SQL export scripts in SQL Developer in the new server, same Apex version but noticed a few odd things.
Some of the apps , not all, had imported into the workspace COM.ORACLE.APEX.REPOSITORY.
I am now trying to delete them so I can re-import to the correct workspace but when I run the following script, connected as SYS.
begin
apex_application_install.set_workspace('COM.ORACLE.APEX.REPOSITORY');
apex_application_install.set_keep_sessions(false);
apex_application_install.remove_application(nnnn);
end;
I get PL/SQL procedure successfully completed.
the app is not deleted. I run the script again and get
ORA-20987: APEX - Invalid application ID. - Contact your application administrator.
Details about this incident are available via debug id "3001".
ORA-06512: at "APEX_200100.WWV_FLOW_ERROR", line 1132
ORA-06512: at "APEX_200100.WWV_FLOW_ERROR", line 1499
ORA-06512: at "APEX_200100.WWV_FLOW_APPLICATION_INSTALL", line 613
ORA-06512: at line 5
I run again and get PL/SQL procedure successfully completed.
the app is never deleted. Seems to be a bug or need an alternative method to delete an app from SQL Developer. Any ideas
Kareem