how to call a javascript on PLSQL

SEKOOK JANG · Dec 2, 2021 1:28AM

Hi,

When i click a button, as a DA, i write as next.

execute javascript code:

window.open( apex.item("P55_CALL_URL").getValue(), "_new");

but, i want call it on PLSQL.

please let me knwo how to code for that.

Thanks.

Billy Verreynne · Dec 2, 2021 5:34AM

Create an APEX dynamic action (Javascript that is executed in the browser), that has a PL/SQL action (that is executed in the database).

An AJAX call will be made by that dynamic action when run. This AJAX call is (via ORDS) to the database for executing the PL/SQL code.

Example:

with properties:

Forum Stats