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!

Loss of source code when compiling. Reproducible bug.

DataProcessingSep 30 2025

Using versions 25.2.2 and 25.1.1 - Source code statements are being unexpectedly deleted. This is a reproducible bug.

Copy / paste and compile then run the code provided below or your code. Make any changes you want but don't compile immediately. Next “select” any code segment, perhaps the “loop” keyword or anything else, either a variable or an entire line. While the selection is highlighted, click compile icon. The compiler will attempt to compile the selection e.g. “loop” (or whatever is selected). this will not compile. Check the SCRIPT_OUTPUT panel, you'll see the compiler error.

SQL> loop
Error starting at line : 1 in command -
loop
Error report -
Unknown Command

In the editor NOTICE all of the code changes are deleted! I've experienced this several times and lost a significant amount of time rewriting lost code until I realized what was happening.

If you immediately press UNDO - Ctrl+Z ASAP after compiling, you can restore your lost changes! But, if you scroll the code of a large package, the code changes are not in plain view and when you compile (with something selected as described) you won't notice the changes were deleted until you start testing and discover no change in runtime behavior! Then you review the source code and discover the changes are gone! Please consider this a critical issue as there is loss of code.

create or replace procedure plsql_settings is 
begin 
      sys.dbms_output.enable; 
      sys.dbms_output.put_line(' Session Initialization'); 
      for r in ( 
        select NAME, VALUE 
          from V$PARAMETER 
         where name LIKE 'plsql%' 
      ) loop 
      sys.dbms_output.put_line(rpad(upper(r.name),40)||r.value); 
  end loop; 
end;
This post has been answered by thatJeffSmith-Oracle on Oct 7 2025
Jump to Answer
Comments
Post Details
Added on Sep 30 2025
4 comments
103 views