27.21 EXECUTE_PLSQL Procedure Signature 2
This procedure executes PL/SQL code based on the current process or plug-in location settings.
Syntax
APEX_EXEC.EXECUTE_PLSQL (
p_plsql_code IN VARCHAR2 )Parameters
| Parameter | Description |
|---|---|
p_plsql_code |
PL/SQL code to execute. Based on the settings of the current process or process-type plug-in, the code is executed locally or remote. |
Example
Executes a PL/SQL block.
BEGIN
apex_exec.execute_plsql(
p_plsql_code => q'#begin :P10_NEW_SAL := salary_pkg.raise_sal( p_empno => :P10_EMPNO ); end;#' );
END;Parent topic: APEX_EXEC