SQL Developer for VS Code

Hi,

We often execute external scripts like “@C:\path\to\script.sql”. If there are empty lines in middle of SQL statement, the script fails. Same script runs fine in original SQL developer.

As an example if I call script containing:

select 'abc', 

'def' from dual;

In VS code I get:

SQL> @C:\path\test.sql
SQL> select 'abc', 
SQL> 'def' from dual;

Error starting at line : 3 File @ C:\path\test.sql
In command -
'def' from dual
Error report -
Unknown Command

In original SQL developer it runs fine:

SQL> @C:\path\test.sql
SQL> select 'abc', 
  2  
  3  'def' from dual;

'ABC'    'DEF'    
abc      def      

1 row selected. 

This is silly example, but we have lots of scripts where complex SQL statements contain empty lines for better readability.