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!

Compilation is deleting /* comments */ at end of the source file.

DataProcessingJul 19 2025

Use this sample code to reproduce the issue.

create or replace procedure P_SAMPLE
authid current_user
is
v_variable$ varchar2(125 char);
begin
v_variable$ := 'some value';
end;
/*
(1) MAKE SURE YOU INCLUDE SOME COMMENT BLOCK LIKE THIS.

SCRIPT\_OUTPUT:   
Procedure P\_SAMPLE compiled

Notice that when the compilation starts, source lines are selected in the worksheet when the Compile icon is clicked.
The comment block DOES NOT GET SELECTED.

Immediately after the compilation is done, the comment block is deleted - GONE.

Furthermore, close worksheet. Reopen proc from the Schema tree and verify.

COMMENT SECTION IS NOT PRESENT!

IMO, commentary might include valuable documentation and should not be removed by the compilation process.

*/

Comments
Post Details
Added on Jul 19 2025
1 comment
215 views