span8
span4
span8
span4
For Oracle spatial tables and views to be recognized by the FME:
|ERROR |Execution of statement `SELECT "PARCEL_VIEW"."PARCEL_ID", "PARCEL_VIEW"."PRIMARYINDEX", "PARCEL_VIEW"."LANDUSE", "PARCEL_VIEW"."USES", "PARCEL_VIEW"."GEOM" FROM ( SELECT * FROM "PARCEL_VIEW" A WHERE MDSYS.SDO_RELATE( A.GEOM, mdsys.sdo_geometry(2003,NULL,null,mdsys.sdo_elem_info_array(1,1003,3),mdsys.sdo_ordinate_array(3118280.75,10081402,3137693.75,10098911)),'mask=ANYINTERACT querytype=WINDOW') = 'TRUE' ) "PARCEL_VIEW" WHERE 1 = 1' did not succeed; error was `ORA-29902: error in executing ODCIIndexStart() routine
Then the spatial metadata probably does not exist. The highlighted NULL entry in the message above should be the SRID.
When Oracle spatial tables are created using SQL Plus or some other tool there may not be entries in the MDSYS.SDO_GEOM_METADATA table that defines the extents and coordinate system of data. You can check for your metadata entries usiing:
select * from USER_SDO_GEOM_METADATA where table_name='