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 18.104.22.168.40
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