SQL Developer for VS Code is excellent news, thanks!
Compilation seems to take forever, so I generated a procedure using the following script:
WITH x AS ( SELECT ROWNUM AS i FROM dual CONNECT BY ROWNUM <= 1000 )
SELECT 'CREATE OR REPLACE PROCEDURE vs_code_test_proc AS' FROM dual UNION ALL
SELECT ' c_' || i || ' CONSTANT PLS_INTEGER := ' || i || ';' FROM x UNION ALL
SELECT 'BEGIN' FROM dual UNION ALL
SELECT ' dbms_output.put_line( c_' || i || ' );' FROM x UNION ALL
SELECT 'END vs_code_test_proc;' FROM dual;
With SQL Developer, the resulting script with 1000 constants compiles immediately.
-
With VS Code, it takes more than 30 seconds, first “Preparing for execution” and then “Query Runner”.
-
I also made the mistake of selecting the whole text and then using “Run in SQLcl”. It pastes everything into the TERMINAL and gets slower with every line - I doubt that it would finish in an hour.
-
Generating the same procedure with 2000 constants instead leads to a StackOverflow exception when trying to compile.
Can you reproduce any of this? Thanks!