I would like to know if you can make an intersection between lines and polygons in oracle spatial, I'm trying to do it in the following way and I can not do it.
thanks
create table prueba.INTER AS (SELECT s.NAME, p.codi ,
SDO_GEOM.SDO_LENGTH(
SDO_GEOM.SDO_INTERSECTION(p.geometry, s.Geometry,0.01),
0.01 ) length
FROM prueba.dren p, prueba.telf s
WHERE SDO_ANYINTERACT (s.geometry, p.geometry) = 'TRUE')
;