I registered few 3d features in GSA (Powermap v8i v08.11.07.97) from existing Oracle 10g database. To connect to database I'm using oracle client 11.1. When I'm executing query database from view Powermap is creating sql similar to:
SELECT GGAZ.PEGAZ_ODCINEK_GAZ_LN.G3E_FID ,'GGAZ_PEGAZ_ODCINEK_GAZ_LN' ,GGAZ.PEGAZ_ODCINEK_GAZ_LN.G3E_FID ,GGAZ.PEGAZ_ODCINEK_GAZ_LN.G3E_CID ,GGAZ.PEGAZ_ODCINEK_GAZ_LN.G3E_CNO ,GGAZ.PEGAZ_ODCINEK_GAZ_LN.G3E_FNO ,GGAZ.PEGAZ_ODCINEK_GAZ_LN.G3E_ID ,GGAZ.PEGAZ_ODCINEK_GAZ_LN.LTT_DATE ,GGAZ.PEGAZ_ODCINEK_GAZ_LN.LTT_ID ,GGAZ.PEGAZ_ODCINEK_GAZ_LN.LTT_STATUS ,GGAZ.PEGAZ_ODCINEK_GAZ_LN.LTT_TID ,GGAZ.PEGAZ_ODCINEK_GAZ_LN.ZNACZNIK_IMPORTU ,GGAZ.PEGAZ_ODCINEK_GAZ_LN.G3E_GEOMETRY FROM GGAZ.PEGAZ_ODCINEK_GAZ_LN
WHERE
SDO_FILTER ( GGAZ.PEGAZ_ODCINEK_GAZ_LN.G3E_GEOMETRY,
SDO_GEOMETRY(3007, 2178, NULL, SDO_ELEM_INFO_ARRAY(1, 1006, 6, 1, 1003, 1, 16, 1003, 1, 31, 1003, 1, 46, 1003, 1, 61, 1003, 1, 76, 1003, 1), SDO_ORDINATE_ARRAY( 7427165,38323555, 5488881,03895589, -100, 7427165,38323555, 5489403,20002557, -100, 7427887,22169813, 5489403,20002557, -100, 7427887,22169813, 5488881,03895589, -100, 7427165,38323555, 5488881,03895589, -100, 7427165,38323555, 5488881,03895589, -100, 7427887,22169813, 5488881,03895589, -100, 7427887,22169813, 5488881,03895589, 1000, 7427165,38323555, 5488881,03895589, 1000, 7427165,38323555, 5488881,03895589, -100, 7427887,22169813, 5488881,03895589, -100, 7427887,22169813, 5489403,20002557, -100, 7427887,22169813, 5489403,20002557, 1000, 7427887,22169813, 5488881,03895589, 1000, 7427887,22169813, 5488881,03895589, -100, 7427887,22169813, 5489403,20002557, -100, 7427165,38323555, 5489403,20002557, -100, 7427165,38323555, 5489403,20002557, 1000, 7427887,22169813, 5489403,20002557, 1000, 7427887,22169813, 5489403,20002557, -100, 7427165,38323555, 5489403,20002557, -100, 7427165,38323555, 5488881,03895589, -100, 7427165,38323555, 5488881,03895589, 1000, 7427165,38323555, 5489403,20002557, 1000, 7427165,38323555, 5489403,20002557, -100, 7427165,38323555, 5488881,03895589, 1000, 7427887,22169813, 5488881,03895589, 1000, 7427887,22169813, 5489403,20002557, 1000, 7427165,38323555, 5489403,20002557, 1000, 7427165,38323555, 5488881,03895589, 1000)), 'querytype=WINDOW') = 'TRUE'
Oracle returns error ORA-13369: niepoprawna wartość etype w formacie 4-cyfrowym format
Table has primary index and spatial index defined as
CREATE INDEX "GGAZ"."PEGAZ_ODCINEK_GAZ_LN_SIDX" ON "GGAZ"."PEGAZ_ODCINEK_GAZ_LN" ( "G3E_GEOMETRY" ) INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" PARAMETERS ('LAYER_GTYPE=MULTICURVE SDO_INDX_DIMS=3');and contains 3d elements, spatial index is valid
Could anyone tell me what im doing wrong? I need very very much this functionality because table contains 250k+ elements.