3 Replies Latest reply: Aug 5, 2013 8:21 AM by Ying Hu-Oracle RSS

    ORA-13226 and imtermediate result sets

    JackeyCheung

      Hi,

       

      I've got a query like this: SELECT SDO_GEOM.SDO_INTERSECTION(t2.GEOM, t1.GEOM, 1E-7) AS GEOM FROM t1 JOIN t2 ON t2.id=t1.id

      The query yields correct intersections of the two table. But these intersections are not really what I need. What I need is something further, as:

      SELECT T3.ID,T3.GEOM FROM T3

          JOIN (SELECT SDO_GEOM.SDO_INTERSECTION(t2.GEOM, t1.GEOM, 1E-7) AS GEOM

                  FROM t1 JOIN t2 ON t2.id=t1.id) T4

              ON SDO_FILTER(T4.GEOM, T3.GEOM);

       

      However, the query yields ORA-13226 error. Am I getting it wrong? Or is it true that I can't do that?