(SQL Dev for VSCode 24.3.1; VSCode 1.86.2; Windows 11)
Test scripts:
a) test-sqp-accept.sql
clear screen
accept def_answer number default "3.14159265" prompt "Give me a number please "
prompt The answer is &&def_answer
b) call-test-sqp-accept.sql
@@test-sqp-accept
When the latter (call-test-sqp-accept.sql) is opened in a SQL worksheet and run as a script (F5), nothing seems to happen: the script output tab remains empty.
When the former (test-sqp-accept.sql) is opened in a SQL worksheet and run as a script (F5), the following panel appears:
Which is not really what was expected.
And then if I click on the Apply button nothing else happens; the script output tab remains empty too.
(Expected behaviour: same as in SQL Dev “Classic”.)
And if I press F5 at that stage to try again, then the following dialog box appears, rather surprisingly.
Regards,