Question

SQL Creator: OCI_NO_DATA /fetch out of sequence error

  • 26 April 2019
  • 1 reply
  • 7 views

Badge

I have sqlcreator which has simplest ever query which selects all fields from a geodatabase table. The SQLCreator does give out the result in an inspector but at the same time throws the following errors.

What am I doing wrong here?

FME Desktop: 2018.0.1.1


1 reply

Badge +1

I would look at this link, it came up in another post

https://knowledge.safe.com/questions/90900/sql-creator-cannot-read-shape.html

What I find a lot of times is the SDO_GEOMETRY in Oracle is invalid or the number of coordinates for the geometry are not correct so FME is seeing issues where you XY\\Z\\M are out of range.

I use Oracle SDO Geometry a lot and have found that I needed to "validate" the geometries number of points. I also use the SQL Creator when working with SDO just because I can alias the table name and use a where clause making sure I am reading the correct geometry type.

i.e.

select ID,GEOM from ownere.table a where a.geom.sdo_gtype = 3302 and sdo_util.getnumvertices(a.shape) > 1;

Reply