Thread: Nested Table having more than 1 column comparison using ORACLE MULTISET

Madhu, I am totally amazed. I didn't think any of the MULTISET operations would work with NTs of records. Lucky you! As for the EXCEPT, well, clearly it is a restriction or bug in PL/SQL. You may want to report it to Oracle Support. Regards,SF At 11:45 AM 10/1/2009, you wrote: Dear Steven, I am using ORACLE 10gR2 Database. I am currently trying to compare two sets of data that I get from two queries in PL/SQL. I want to use Oracle...

Hi Madhu, I have the same problem and i solved problem like below. Try if it will help you. Create type object in database and use it for the multiset except. As per my experience If you assign the values statically to the array it will work but if you assign it by dynamically using bulk collect it doesn't work. Its only happening for the multiset except only. For remaining operations it works fine. (CREATE OR REPLACE TYPE type...