Skip to Main Content

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.

Apex Authorization Scheme PL/SQL: how to get the name of button tested ?

user7911366Jun 23 2021 — edited Jun 23 2021

This is a simple example to show where I want to identified the button tested that have the Security
Authorization Scheme property set to this scheme

image.png

This post has been answered by user7911366 on Jun 24 2021
Jump to Answer

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
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 22 2021
Added on Jun 23 2021
8 comments
579 views