EXECUTE_PLSQL_CODE Procedure (Deprecated)

45.12 EXECUTE_PLSQL_CODE Procedure (Deprecated)

Note:

This API is deprecated and will be removed in a future release.

Use EXECUTE_PLSQL Procedure Signature 1 or EXECUTE_PLSQL Procedure Signature 2 instead.

This procedure executes a PL/SQL code block and performs binding of bind variables in the provided PL/SQL code.

Syntax

APEX_PLUGIN_UTIL.EXECUTE_PLSQL_CODE (
    p_plsql_code      IN VARCHAR2,
    p_auto_bind_items IN BOOLEAN     DEFAULT TRUE,
    p_bind_list       IN t_bind_list DEFAULT c_empty_bind_list );

Parameters

Parameter	Description
`p_plsql_code`	PL/SQL code to be executed.
`p_auto_bind_items`	Whether to auto-bind APEX items (page and application items).
`p_bind_list`	Additional bind variables to be used for the SQL query.

Example

Text which should be escaped and then printed to the HTTP buffer.

DECLARE
    l_plsql_code VARCHAR2 := p_process.attribute_01;
BEGIN
    apex_plugin_util.execute_plsql_code (
        p_plsql_code => l_plsql_code );
END;

Parent topic: APEX_PLUGIN_UTIL