My Oracle Support Banner

ORA-01722 When Deleting A Theme From An Application (Doc ID 397272.1)

Last updated on FEBRUARY 09, 2023

Applies to:

Oracle Application Express (APEX) - Version to [Release APEX 2.0 to APEX 2.2]
Information in this document applies to any platform.
This problem can occur on any platform.


You receive the following error when trying to delete themes from the Shared Components:

ORA-01722: Invalid Number

Steps to reproduce the problem :

1) Log in to workspace.
2) Click Application Builder.
3) Select Application.
4) Click Shared Components.
5) Click Themes.
6) Click Delete Theme.
7) Select any theme.
8) Click Next.
9) Click Delete Theme.

This results in the above error and is encountered for all themes which have either been :

- Created from the repository


- Imported into the application


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.