Cannot read Oracle Spatial - bad geometries

Liz Sanderson
Liz Sanderson
  • Updated

FME Version

  • FME 2015.x

Symptom

FME Oracle Spatial reader fails with an error message like:
 ERROR |Error converting Oracle Spatial object geometry type to an integer: message was `An error occurred converting an Oracle OCINumber object to an integer: `OCI-22060: argument [2] is an invalid or uninitialized number

Cause

Probable cause is an invalid geometry in the Oracle Spatial column

Resolution

Validate the Oracle geometry:

      select sdo_geom.validate_geometry (<tablename>, geom, 0.5) from <tablename>

You may need to change "geom" to match the name of the geometry column.

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.