Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

25.4.1: Open '[' makes all text red

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?

This post has been answered by thatJeffSmith-Oracle on Feb 18 2026
Jump to Answer
Comments
Post Details
Added 4 days ago
2 comments
90 views