I am struggling to read two geometry columns from this database. If I set Handle Multiple Spatial Columns to "No", it only gives me one of the two columns. If I set it to "Yes", then I get the above error.
What does it mean to have a "Custom SQL SELECT statement"?
Mine is nothing fancy:
select building_id, floor_id, space_id, agency_code, space_type, space_category,usable_sq_ft,
obj.objgeom,
SDO_UTIL.interior_point (OBJ.objgeom)
from esm.esmobject obj join esm.att_space ats
on obj.IDOBJECT = ats.IDOBJECT
where building_id = 'BD0303'
and floor_id = '01'
It was also difficult to retrieve data tables. I had to type in each one. Luckily there were only two. If I let FME search for tables, it errors:
My connection seems fine. I am able to access all tables and do more complicated queries in SQL Developer.
Any info is appreciated.
Thanks,
Loren