| Multiset union error [message #266983] |
Wed, 12 September 2007 03:22  |
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
