Is there a way to compare Ref cursor outputs directly in pl sql developer version 9? Our existing procedures have been modified to improve performance. In this context we have to ensure that there is no data mismatch.How can we compare 2 refcursor s coming from different procedures?
compare Refcursor outputs
- Thread starter Sravz
- Start date
You will have to export the results to a file (e.g. in CSV format) for both procedure versions and then use a file compare tool (e.g. ExamDiff as provided with PL/SQL Developer) to compare the 2 result sets.
No, this is currently not possible.
patch
Member³
You can build tablefunctions around your refcursor procedures and use SQL to check for differences.
Check the script I whipped up:https://livesql.oracle.com/apex/livesql/file/content_CPXYY29JKT0R2UL6VKHUFLSIU.html
Check the script I whipped up:https://livesql.oracle.com/apex/livesql/file/content_CPXYY29JKT0R2UL6VKHUFLSIU.html
Similar threads
- Discussion
