Why is this an issue?
Procedures, unlike functions, do not return values. The
RETURN statement therefore, when used within a procedure, is used to
prematurely end the procedure. However, having multiple exit points (i.e. more than the
END of the procedure itself), increases the
complexity of the procedure and makes it harder to understand and debug.
Noncompliant code example
SET SERVEROUTPUT ON
PROCEDURE prcoedureWithReturn AS
RETURN; -- Noncompliant
DBMS_OUTPUT.PUT_LINE('prcoedureWithReturn called'); -- This is actually unreachable