1 Reply Latest reply: Mar 13, 2012 3:16 AM by wkobargs-Oracle RSS

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

    922027
      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