I've searched all available online sources but none appear to have this issue.
I've added an Oracle Spatial Reader, connected to desired table and now want to extract x/y but I get this error when running.
Error - Cannot have NULL value for 'z coordinate'
I've looked at the table in Oracle developer and indeed the Z values are Null.
I'm aware that this table has multiple Spatial columns so I've checked: Handle Multiple Spatial Columns: Yes
I've tried a SELECT statement to run before translation:
SELECT c.GEOM.SDO_POINT.X AS X, c.GEOM.SDO_POINT.Y AS Y, FROM A.ENTITIES c WHERE ACCESS_CODE = 'O'
I've tried to expose the attributes: oracle_sdo_point.x oracle_sdo_point.y oracle_sdo_point.z
Is there a way to force this to 2D rather than looking at the Z values?