When running the below script with the different options in SQL Developer for VS Code, it works when executed with the "Run in SQLcl (Ctrl + Shift + Enter)" button but when executed with the “Run Script (F5)” button a VS Code dialog prompts for a substitution variable value.
Not sure whether this is a bug or something mis-configured in my environment?
This works fine in standard/standalone SQL Developer, using “Run Script (F5)”.
Thanks.
COLUMN log_file new_value log_file NOPRINT
SELECT 'output.log' log_file FROM dual;
SPOOL &log_file
SELECT object_name FROM all_objects FETCH FIRST 10 ROWS ONLY;
Run in SQLcl (Ctrl + Shift + Enter)
SQLcl: Release 23.3 Production on Mon Jan 29 13:21:22 2024
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.21.0.0.0
LOG_FILE
_____________
output.log
OBJECT_NAME
______________
OBJ$
CCOL$
CLU$
SEG$
I_OBJ3
ICOL$
I_OBJ2
FILE$
I_CCOL1
I_OBJ#
10 rows selected.
SQL>
Run Script (F5)
