This discussion is archived
1 Reply Latest reply: Mar 13, 2012 1:16 AM by wkobargs RSS

ORA-22901: cannot compare nested table or VARRAY or LOB attributes of an ob

922027 Newbie
Currently Being Moderated
Hi,
I want to compare the complete nested table record for checking if the data is already present or not
Please find below is the query...

select column_value from Emp e, table(Language_known) ln
where Language_known=NESTYPE('HINDI','ENGLISH');

but i am getting the below error..

Cause: Comparison of nested table or VARRAY or LOB
attributes of an object type was attempted in the absence of
a MAP or ORDER method.

Action: define a MAP or ORDER method for the object type.

Please add more information about this Error.
Or
How can i compare the object value.


Thanks in Advance

Legend

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