Home » SQL & PL/SQL » SQL & PL/SQL » Multiset union error
Multiset union error [message #266983] Wed, 12 September 2007 03:22 Go to next message
deb_orafaq
Messages: 2
Registered: February 2007
Location: Kolkata
Junior Member
Hi,
I am trying to merger contents of two collection to a third collection , but getting the following errors.
NB- All three are declared and initialized to the same type

The Error Line is, rec := rec1 MULTISET UNION rec2;


Error: PLS-00801: internal error [*** ASSERT at file pdw4.c, line 2080; Type 0xffffffff79efe3f0 has no MAP method.; PKG!__SCOTT__B__61274[6]
Line: 6463
Text: rec := rec1 MULTISET UNION rec2;
Re: Multiset union error [message #266995 is a reply to message #266983] Wed, 12 September 2007 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
MULTISET UNION eliminates duplicates so it requires a way to order and compare the objects and it needs a MAP method.
Your type doesn't have any, so it can't be done.

If you don't want/need to eliminate duplicates use MULTISET UNION ALL.

Regards
Michel

[Updated on: Wed, 12 September 2007 03:49]

Report message to a moderator

Re: Multiset union error [message #267056 is a reply to message #266983] Wed, 12 September 2007 06:40 Go to previous messageGo to next message
deb_orafaq
Messages: 2
Registered: February 2007
Location: Kolkata
Junior Member
Hi Michel,

Thanks Michel for your prompt answer. But I am afraid the precribed soultion is showing the same error.

Thanks and regards

Deb
Re: Multiset union error [message #267057 is a reply to message #267056] Wed, 12 September 2007 06:45 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So the solution is to add a MAP function to your type.

Regards
Michel
Previous Topic: To know privileges under each role
Next Topic: How can we rollback DDL changes (3 topics merged)
Goto Forum:
  


Current Time: Sat Dec 03 15:49:57 CST 2016

Total time taken to generate the page: 0.14525 seconds