Comp_id 'SDO' Is Missing In Dba_Registry Though Locator Has Been Installed (Doc ID 1662822.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

comp_id 'SDO' is missing in dba_registry though Locator has been installed

A software vendors (Bentley) is using 'select sdo_version from dual' to check whether Locator functionality is available.
Unfortunately, this query returns NULL because the instance has no comp_id = 'SDO' in the dba_registry.
It contains only CATALOG, CATPROC, OWM, JAVAVM, XML, CATJAVA, EXF, XDB, RUL, ORDIM, EM, CONTEXT.

The situation is that neither our application vendor is able to change his application nor am I willing to tweak the function mdsys.SDO_VERSION.


We provided workaround to customer to return the 11.2.0.3.0 string but he didn't like to hardcode so we provided one based on ORDIM

conn / as sysdba
alter session set current_schema=MDSYS;

create or replace function SDO_VERSION
return varchar2 DETERMINISTIC PARALLEL_ENABLE as
sdo_verno VARCHAR2(30);
begin
select VERSION into sdo_verno
from dba_registry where comp_id = 'ORDIM';
return sdo_verno;
end;
/
exit

Still customer is hesitant to use this workaround and would like Oracle to modify the SDO_VERSION function to deal with the case where Locator is installed but not Spatial.

Cause

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