This discussion is archived
3 Replies Latest reply: Aug 5, 2013 6:21 AM by yhu RSS

ORA-13226 and imtermediate result sets

JackeyCheung Newbie
Currently Being Moderated

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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points