Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
General Database Discussions
Database and Application Migrations
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Mar 13, 2012 3:16 AM by
ORA-22901: cannot compare nested table or VARRAY or LOB attributes of an ob
Mar 12, 2012 12:45 AM
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
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.
How can i compare the object value.
Thanks in Advance
This content has been marked as final.
Show 1 reply
Re: ORA-22901: cannot compare nested table or VARRAY or LOB attributes of an ob
Mar 13, 2012 3:16 AM
in response to
this forum is dedicated for the migration of non-Oracle databases to Oracle, using the SQL Developer Migration Workbench. We can't help you much. A quick search for ORA-22901 showed that appears in questions in the following forums:
Forum: SQL and PL/SQL -
SQL and PL/SQL
Forum: Spatial -
So you should better ask in these forums.