I have tried the Oracle SQL Developer Extension for VSCode (version 25.2.0 on VSCode 1.102.0) and have noticed issues with code completion:
When I write an anonymous PL/SQL block with, e.g., a function declared here in this block, the code completion does not show this function. In this example, with the cursor in put_line and writing “my” I would expect code completion to suggest the “my_func” function. However, code completion does not suggest this function. It looks like only schema objects from the database connections are shown. Of course, copilot might work in this case but the usual code completion should also be able to suggest this function.
declare
function my_func return number is
begin
return 1;
end;
begin
dbms_output.put_line(my);
end;
Another thing I have noticed is that code completion show PL/SQL packages and also function or procedures in this function. However it has no code completion for the parameters. After writing the opening brace no code completion is given.
Are these known limitations or some kind of bugs? The “Oracle SQL Developer Extension for VSCode” looked quite nice in the beginning, but from the firsts real world tests in PL/SQL software development it looks like it isn't ready for production use.