*
The moose likes Oracle/OAS and the fly likes ORA-22950: cannot ORDER objects without MAP or ORDER method Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "ORA-22950: cannot ORDER objects without MAP or ORDER method" Watch "ORA-22950: cannot ORDER objects without MAP or ORDER method" New topic
Author

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

Prabha Dhandapani
Ranch Hand

Joined: Sep 11, 2003
Posts: 70
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

Joined: Feb 05, 2001
Posts: 17250
    
    6

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


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17250
    
    6

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-22950: cannot ORDER objects without MAP or ORDER method