BUG
After inserting features using SQL (e.g., using an ST_GEOMETRY or SDO_GEOMETRY operator) and attempting to label the inserted features in ArcMap, the feature's labels disappear when zooming in to a large scale. This behavior occurs when the inserted features exist beyond the feature class extent. The issue impacts feature classes with ST_GEOMETRY or SDO_GEOMETRY storage types.For example:
Code:
DECLARE
v_registation_id number(8);
v_srid NUMBER(8);BEGIN SELECT registration_id INTO v_registation_id
FROM sde.table_registry
WHERE table_name = 'POLES'; SELECT srid INTO v_srid
FROM SDE.st_geometry_columns
WHERE (owner = USER AND table_name = 'POLES'); INSERT INTO roads (OBJECTID,LABEL,SHAPE) VALUES
(sde.version_user_ddl.next_row_id(USER, v_registation_id),
'ID_298',
sde.st_geometry('POINT ( 9689097.37142934 4423553.842365312)', v_srid)); COMMIT;
When inserting features with SQL (e.g., using ST_GEOMETRY or SDO_GEOMETRY operators), the feature class' extent is not automatically updated or expanded to include the new feature.
Code:
sdelayer -o alter -E calc -l poles,shape -i esri_sde -u username -p password
Article ID:000010688
Get help from ArcGIS experts
Download the Esri Support App