Tuesday 15 June 2010

oracle - Comparison of 2 Nested Tables Will Not Compile -


Here's the idea of ​​creating a nested table, then load another nested table from PL / SQL query and compare two In the bar:

  Package Body ... Process Definition ... Cursor CX * Choosing * from the table; Type TCX table is CX% ROWTYPE; RSOldData TCX; RSNUdata TCX; ... loads RSN data with data ... Open CX; Collect the CSX Bulk in rsOldData; Close cx; If rsOldData! = RSNEdata so ... do something ... if the end; Bla, bla, bla, everything else  

The problem is, the comparison of two nested tables will not compile. I have tried both equation and do not have equality, so this is not symbology.

I will try to form a standalone type and see that it will make a difference.

Here is the answer. According to "Use of PL / SQL Collection with SQL Statement":

Comparison of records

Can not be tested for the futility of records or Compared to equality or inequality ...

I think that sinks too much.


No comments:

Post a Comment