This content has been marked as final. Show 3 replies
The problem I have found with this is that is seams to work fine except in situations where you have a WHEN in you package/function.
Two examples that I have found will not collaspse the code correctly is where there is an exception clause present. The code will collaspe upto the WHEN clause, take out the WHEN clauses and it collapses fine.
when others then
The other example is when using a WHEN statement within a cursor which you can do with the CASE statement, this causes the collaspse functionality to also fail.
select (case when amount is not null then ..........
Other than that I`m liking RAPTOR so far, thumbs up.....
Hope that helps folks.