laptop and a wrench

Bug

The ST_Geometry: Query misses features with NULL geometries and returns an incorrect result set, or fails with SE_ROW_NOEXIST (-22) if the first feature in result set contains a NULL geometry.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM012273
SubmittedOctober 11, 2007
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found9.2
Version Fixed9.3
StatusFixed

Description

The first row is not visible in the attribute dialog box when editing if the geometry type is ESRI Spatial Type in Oracle and the first row contains a NULL geometry.

Cause

This is a known issue.

Workaround

Using the ArcSDE spatial functions, update the first row in the business table so the spatial column is no longer NULL.

Use the INSERT command to insert a new feature. For example:

Code:
INSERT INTO waterpolys VALUES (st_polygon('polygon ((10000 520000,1
00008889 55000, 1045545983 234280934, 10000 520000))',9));

Refer to the ArcGIS Help for information on creating features using ESRI Spatial Type functions: ArcGIS Help-Working with the Spatial Type

Steps to Reproduce

Bug ID: NIM012273

Software:

  • No Product Found

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options