Code Analysis: Rule 3807 vs 5601 (Avoid using RETURN statements in a PROCEDURE)

Toad for Oracle - Beta
1

Both rules seem to be the same. I guess that one of them is new and should replace the other one?

2

Peter,

I guess you’ll be right. We’ll consolidate these. (QP-2012)

In your opinion, which of both is the best?

Thanks,
Andre

3

Well, I’m not in a position to compare the XPath queries, but 5601 has a very detailed description.

BTW: The example of 5601 contains an extra single-quote so it won’t compile, and it should actually be rewritten to use CASE instead of IFs -> rule 4213 :wink:

4

Thank you. No I didn’t mean comparing XPath, only considering what comes out. We’ll combine the best elements of both.