> If i create a VDB on top of Oracle DB having geometry data type. Would it be possible to fetch the data of this column by connecting to this VDB through teiid JDBC driver ? If yes what will be type CLOB ?
Prior to 8.10 you could retrieve the geometry column as a struct. With 8.10 and later you can use the importer option useGeometryType to have the column imported as a Teiid Geometry type. From a client perspective the Teiid geometry type can be used as a clob.