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.