Hello:

I have the following problem when using variables indicating the procedure / function name. First of all the Highlight variables doesn't work. And "Refactoring -> Rename item" it doesn't work either.


Best Regards,

Attached picture p1.png
Attached picture p2.png
Attached picture p3.png
We'll enhance this.
Hello:

Another problem with refactoring is with -variable: Example:

CREATE OR REPLACE FUNCTION f_test RETURN NUMBER IS
v_number NUMBER := 2;
BEGIN
v_number := -v_number;
RETURN(v_number);
END;

If variable v_number is refactored to v_number2, this is the result:

CREATE OR REPLACE FUNCTION f_test RETURN NUMBER IS
v_number2 NUMBER := 2;
BEGIN
v_number2 := -v_number;
RETURN(v_number2);
END;

Thanks
© Allround Automations forums