Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-22950: cannot ORDER objects without MAP or ORDER method

 
Prabha Dhandapani
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
OK I just saw this.

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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic