ORA-22950: cannot ORDER objects without MAP or ORDER method
posted 13 years ago
Hello everybody, I have a SQL Script that does some select form different tables.Below is my query:
When I execute this script: I get the following error: SELECT * ERROR at line 1: ORA-22950: cannot ORDER objects without MAP or ORDER method Can somebody tell me what the error is?I assume it is related to the group by clause but not able to find the bug.This is very very urgent.Help wanted from Ranchers! Thanks, Prabha
1st, it is a big query, one way to debug queries to to take a little off, bit by bit till it runs, then you know the last thing you moved was a cause. Not necessarily the only problem though. Another thing I noticed, and it depends on how you are running the lines, but I don't see a semi-colons, well you do have slashes, so that might be nothing. Other than that the query looks good to me. Mark
ORA-22950: cannot order objects with without map or order method Cause: Object types must have map or order methods defined for all comparisons other than equality and inequality comparisons. Action: Define a map or order method for the object type.
What that says to me is that there is some kind of Object. Is the Object the document's text? because you use like which might be considered "NOT" an equality or inequality comparison. Just a wild guess. Mark