For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
The SQLcl Integration works fine, but I'm missing the scripting support. Maybe you can embed graalvm instead of the jdk?
We're using Java 21, and it's not straightforward to add the javascript engine support for MLE Java 21 :(
Stay tuned…
Is there a way to add a “hook” to launch into SQLcl as is done in SQL Dev or is that a future thing?
Sorry, not sure I understand what you mean. Can you describe in more detail what you're looking for?
How about running sqlcl local installation in vscode Terminal window and
1.) while editing the file - select the code and use “Terminal: Run Selected Text in Active Terminal”
SQL> script 2 ctx.write("Hello World !\n"); 3* / Hello World ! SQL>
2.) or use the e-trick:
SQL> e hello_world.js SQL best practice warning (2,1): G-1030: Avoid defining variables that are not used PL/SQL procedure successfully completed. Elapsed: 00:00:00.283 Elapsed: 00:00:00.052 1 script 2* ctx.write("Hello World !\n"); SQL> @hello_world.js Hello World ! Elapsed: 00:00:00.115
We're using Java 21, and it's not straightforward to add the javascript engine support for MLE Java 21 :( Stay tuned…
IMO integrating the GraalVM scripting engine should be straightforward (I've done that for other projects). Libs compatible with Java 21 are available on Maven Central. It's sad, that in version 23.3.0 the integrated SQLcl still does not support the script command.
Any estimates on when we can expect support for the script command in the integrated version of SQLcl of SQL Developer for VS Code?