Hi, I'm trying out the extension for vs code as an alternative for SQL Developer, however I got stuck with seemingly easy task such as compiling a package from the extension.
First of all, when I open the package in SQL Developer the first line properly says:
“create or replace NONEDITIONABLE package body…”,
the same package opened in vs code starts with:
“CREATE OR REPLACE package body…”.
Because of that when opening a package in the extension, making any simple change in the code and trying to compile, you will see the error:
“ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object.”
Now, when trying to change manually the line to include noneditionable in the vs code, when compiling you see:
“This editor can be used to modify only 'package_name'.”
So it seems I'm unable to compile it whether using the default header proposed by the extension or manually adjusting the code. The very same create noneditionable executed with Oracle SQL Developer compiles without any issues.