Forum Stats

  • 3,757,088 Users
  • 2,251,194 Discussions
  • 7,869,721 Comments

Discussions

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

starsols
starsols Member Posts: 2 Red Ribbon

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

Best Answer

Answers