Code Analysis glitch with nested function
Kevin Angus <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
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.