Skip to Main Content

SQL Developer for VS Code

Announcement

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.

Feature Request: js-Support for the integrated SQLcl

rode_mbJan 18 2024

The SQLcl Integration works fine, but I'm missing the scripting support. Maybe you can embed graalvm instead of the jdk?

Comments

thatJeffSmith-Oracle

We're using Java 21, and it's not straightforward to add the javascript engine support for MLE Java 21 :(

Stay tuned…

Carl Singer

Is there a way to add a “hook” to launch into SQLcl as is done in SQL Dev or is that a future thing?

thatJeffSmith-Oracle

Sorry, not sure I understand what you mean. Can you describe in more detail what you're looking for?

Paavo

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
Philipp Salvisberg

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?

1 - 5

Post Details

Added on Jan 18 2024
5 comments
204 views