This procedure executes a PL/SQL code block and performs binding of bind variables in the provided PL/SQL code. This procedure is usually used for plug-in attributes of type PL/SQL Code.
Syntax
APEX_PLUGIN_UTIL.EXECUTE_PLSQL_CODE ( p_plsql_code IN VARCHAR2);
Parameters
Table 21-8 EXECUTE_PLSQL_CODE Parameters
Parameter | Description |
---|---|
|
PL/SQL code to be executed. |
Example
Text which should be escaped and then printed to the HTTP buffer.
declare l_plsql_code VARCHAR(32767) := p_process.attribute_01; begin apex_plugin_util.execute_plsql_code ( p_plsql_code => l_plsql_code ); end;