I'd like to have a macro that looks for all defined variables in an (Oracle) Procedure or function that are not used there (maybe list those in a separate new file window, thats ok or -hey- even better: bookmark 'em)
- Code: Select all
PROCEDURE log_queue(p_xml_clob IN CLOB) IS
v_proz VARCHAR2(30) := 'log_queue';
v_from NUMBER := 1;
v_to NUMBER := 4000;
v_ges := 123;
WHILE v_from < v_to LOOP
v_from := v_from + 1;
So here v_notused should be found.
All variables are found between the keywords PROCEDURE/FUNCTION <name> and BEGIN.
PROC/FUNC always ends with END <name>
Just before I start:
- Does anybody of you guys have sth. similar to that, so I don't need to start from scratch ?
- What do you think about it ?