Skip to Main Content
Forums

APEX

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.

Item Substitutions strings not working in interactive grid and report downloading/printing settings

smatzisJun 29 2022 — edited Jun 29 2022

Hello, how are you? I am using the latest apex/ords for my application.
Well the title says it all. As well as the following screenshots.
Page Item Substitutions Strings do not work on "Page Header Text" Fields of Interactive Report/Grid settings. However System Variables do work.
The same behavior applies to "Page Footer Text" and "Supplemental Text" Fields.
(Please not that P5_NEW just has some static text)
image.png
image.png

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
1 person found this helpful
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 person found this helpful
1 - 5

Post Details

Added on Jun 29 2022
#apex, #apex-discussions
7 comments
456 views