OraFAQ Forum: SQL & PL/SQL » ORA-22950: cannot ORDER objects without MAP or ORDER method

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-22950: cannot ORDER objects without MAP or ORDER method (Oracle 10 G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-22950: cannot ORDER objects without MAP or ORDER method [message #318781]

Wed, 07 May 2008 23:37

rangan.s
Messages: 75
Registered: February 2008
Location: chennai

Member

DELETE FROM sample
WHERE EXISTS
(
SELECT * FROM(
select external_id, typeid from sample n join types t on t.id = n.typeid
MINUS
select id , typeid from new_data
)args
join
node
on sample.external_ID = args.external_id and
sample.typeid = args.typeid
);

i am using the above code in my procedure which i am using in my trigger. when i execute my trigger i got the following error

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

Report message to a moderator

Re: ORA-22950: cannot ORDER objects without MAP or ORDER method [message #318785 is a reply to message #318781]

Wed, 07 May 2008 23:58

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

I Think u should want to use in that ways


DELETE FROM sample
WHERE EXISTS
(
SELECT 1 FROM(
select external_id, typeid from sample n join types t on t.id = n.typeid
MINUS
select id , typeid from new_data
)args
join
node
on sample.external_ID = args.external_id and
sample.typeid = args.typeid 
);

kanish

Report message to a moderator

Previous Topic:	Materialized view
Next Topic:	Query Giving Wrong Output

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 06 10:13:21 CDT 2025