Oracle SQL Developer Extension for VSCode version - 24.4.1
Certain scripts no longer run when using the run in SQLcl or Run on Script buttons or shortcut keys in vscode and produce the error.
After experimenting I can run short scripts, if you save the below as test.sql and then run in SQLcl this will work.
spoo hello
set echo on verify on
col text NEW_VALUE text noprint
SELECT 'Hello World' text
from dual;
PROMPT &&text
If I run my script which is around 750 lines of code I get the above error.
If I run the test.sql script and then run my script in the open terminal it executes fine so doesn't appear to be an issue with my script. Is there a limit on the command string that VS code can use or something?
UPDATE - After more testing, it appears that just under 700 lines is the limit. I reduced my script to 694 lines (31305 characters) and that ran successfully. I added another insert statement which took it to 700 lines (31546 characters) and this produced the error message.