SQL Developer Accessing APEX_RELEASE though there is no APEX in the system
Last updated on APRIL 19, 2012
Applies to:Oracle SQL Developer - Version 1.2.1 to 184.108.40.206.40
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
select sql_fulltext from v$sql where lower(sql_fulltext) like '%apex_release%';
whereas SQL Developer returns
select version_no from apex_release
select sql_fulltext from v$sql where lower(sql_fulltext) like '%apex_release%'
select 1 from apex_release where 1=2
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms