Home » SQL & PL/SQL » SQL & PL/SQL » ORA-22950: cannot ORDER objects without MAP or ORDER method (Oracle 10 G)
ORA-22950: cannot ORDER objects without MAP or ORDER method [message #318781] Wed, 07 May 2008 23:37 Go to next message
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

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 Go to previous message
mm_kanish05
Messages: 487
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
Previous Topic: Materialized view
Next Topic: Query Giving Wrong Output
Goto Forum:
  


Current Time: Wed Dec 07 14:56:13 CST 2016

Total time taken to generate the page: 0.11124 seconds