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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Apps somehow imported to COM.ORACLE.APEX.REPOSITORY workspace. Now unable to delete

starsolsSep 24 2021

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

This post has been answered by starsols on Sep 24 2021
Jump to Answer

Comments

Processing

Post Details

Added on Sep 24 2021
1 comment
349 views