I am using the 25.4.1 SQL Developer extension for VS Code. When I have an open square bracket ‘[’ and it is not closed, all text after it appears red. Since I use it in a String this is unwanted behavior.
If I go back to 25.4.0 the red text disappears and is back to usual, so I assume this is a Bug with 25.4.1 and its parsing.
This is an example to recreate the bug:
CREATE OR REPLACE FUNCTION generic_function(p_input IN VARCHAR2)
RETURN VARCHAR2
IS
v_result VARCHAR2(100);
BEGIN
v_result := p_input;
v_result := TRIM(v_result);
v_bracket := '[smth';
v_result := UPPER(v_result);
v_result := SUBSTR(v_result, 1, 50);
v_result := v_result || '';
v_result := REPLACE(v_result, ' ', ' ');
v_result := NVL(v_result, '');
RETURN v_result;
END generic_function;
And this is what it look like for me:

Is there something I can do other than go back or am I missing something?