Toad World® Forums

Code Analysis glitch with nested function

Hi all,

TOAD 11.0.0.116

If I have a function that contains a nested function there is an indication that
it has broken rule 3803, using more than one return statement in a function’s
executable section.

For example,

CREATE OR REPLACE FUNCTION f_get_something(p_param_1 varchar2) RETURN varchar2
IS

FUNCTION f_get_something_else(p_param_2 varchar2) RETURN varchar2 IS

BEGIN

RETURN ‘x’;

END f_get_something_else;

BEGIN

RETURN ‘y’;


END f_get_something;

In the editor there is a squiggly line under RETURN 'y' referencing rule 3803.

Looks like the RETURN in the nested function is confusing it.

Cheers,

Kevin.

Thanks for the info Kevin. We’ll look at updating the rule to make it a bit
smarter.

Greg