My Oracle Support Banner

SQL Developer Accessing APEX_RELEASE though there is no APEX in the system (Doc ID 1262957.1)

Last updated on NOVEMBER 16, 2021

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle SQL Developer - Version 1.2.1 to
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


APEX does not exist in environment at all. The trace file shows SQL Developer is trying to access:
select 1 from apex_release where 1=2.

For example when the following query is issued in sqlplus it fetches 0 rows

The concern here is that when there is no APEX at all why is SQL Developer trying to access APEX apex_release? Does SQL Developer require Oracle Application Express installed or configured?


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.