Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"SDO_JOIN": invalid identifier

564132Mar 27 2007 — edited Apr 2 2007

Hi,

This query is giving an error.. Please help...

SELECT /*+ ordered */ A.id
FROM
TABLE(SDO_JOIN('T_POI', 'GEOLOC','TAB_POS_RECT_BUFFER', 'GEOLOC','mask=ANYINTERACT')) c,
T_POI A,
TAB_POS_RECT_BUFFER b
WHERE A.CLASIFICACION1='ESCUELA' AND c.rowid1 = a.rowid AND c.rowid2 = b.rowid;

Error it gives is :
ORA-00904:"SDO_JOIN": invalid identifier

Thanks
Neha

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2007

Added on Mar 27 2007

#database-key-features, #spatial

6 comments

1,335 views