Re: ORA-22950

Robert Wehofer wrote:

>Hello!
>
>What does the oracle error
>
>"ORA-22950: ORDER command for objects without methods MAP or ORDER not
>possible"
>
>mean?
>
>My SQL statement does not contain any ORDER clauses! It is an INSERT SELECT
>statement.
>
>Regards,
>Robert
>
>
>

It likely means you hare inserting into a user defined data type rather than a regular column.
UDTs can contain either a MAP or ORDER method.

Perform a DESCribe on the table and likely you will find a column that is not NUMBER, DATE,
or VARCHAR2.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)