Article created with
FME Desktop 2010
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.
Can you tell me where to enter the select statement and how to find the name of the geometry column?
Hi
@danellelaurin, the select statement is meant to be used outside of FME in an application such as SQL Developer. You should be able to find the name of the geometry column for your table by using a describe statement (ie- DESCRIBE table;) and locating the column with a geometry type.
Database administrator who can access to the database responded with this message:
"The Table name is called Culvert. If a fully qualified name is required it would be ORI.culvert
The column name is geometry.
The sdo_geom belongs to the schema MDSYS – which is Oracle’s spatial data schema
The package is called validate geometry
It does not matter how I call/execute this statement, or from any account (even SYS) I receive Oracle errors either: ora- 00904 or ora-00942. Please have someone from FME contact me."
"The Table name is called Culvert. If a fully qualified name is required it would be ORI.culvert
The column name is geometry.
The sdo_geom belongs to the schema MDSYS – which is Oracle’s spatial data schema
The package is called validate geometry
It does not matter how I call/execute this statement, or from any account (even SYS) I receive Oracle errors either: ora- 00904 or ora-00942. Please have someone from FME contact me."
Hello @danellelaurin,
I'd recommend reading this article as it has troubleshooting tips for one of the errors mentioned. If this does not solve your issue please open a case with us https://www.safe.com/support/report-a-problem/ If you do decide to open a case please include your workspace, version of FME, and the exact statement you are using.
Thanks,
Sienna
I'd recommend reading this article as it has troubleshooting tips for one of the errors mentioned. If this does not solve your issue please open a case with us https://www.safe.com/support/report-a-problem/ If you do decide to open a case please include your workspace, version of FME, and the exact statement you are using.
Thanks,
Sienna
Contributors
