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!

SQL Error: ORA-22901: cannot compare nested table or VARRAY or LOB attribut

542856Feb 12 2007 — edited Feb 13 2007

select distinct a.id, b.geoloc
from table1 a, table2 b
where a.id=b.id;

(datatype for geoloc is SDO_GEOMETRY)
When I run this code, this is the error I got

Error report:
SQL Error: ORA-22901: cannot compare nested table or VARRAY or LOB attributes of an object type

Could someone please help me fix this error? Your help is greatly appreciate this.
Thanks
Cuong

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 13 2007

Added on Feb 12 2007

#database-key-features, #spatial

3 comments

3,785 views