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