1. API Reference
  2. APEX_EXEC
  3. EXECUTE_REMOTE_PLSQL Procedure Signature 2

27.23 EXECUTE_REMOTE_PLSQL Procedure Signature 2

This procedure executes PL/SQL code on a REST-enabled SQL instance.

Syntax

APEX_EXEC.EXECUTE_REMOTE_PLSQL (
    p_server_static_id     IN     VARCHAR2,
    p_plsql_code           IN     VARCHAR2 )

Parameters

Parameter Description
p_server_static_id Static ID of the ORDS REST-enabled SQL instance.
p_plsql_code PL/SQL code to execute.

Example

Executes a PL/SQL block on a remote database.

BEGIN
    apex_exec.execute_remote_plsql(
        p_server_static_id => '{Static ID of the REST Enabled SQL Service}',
        p_plsql_code  => q'#begin :P10_NEW_SAL := salary_pkg.raise_sal( p_empno => :P10_EMPNO ); end;#' );
END;

Parent topic: APEX_EXEC