41.28 GET_PLSQL_FUNC_RESULT_CLOB Function
This function executes a PL/SQL function block and returns the CLOB result. This function also performs the binding of bind variables in the provided PL/SQL function body. This function is usually used for plug-in attributes of type PL/SQL function body.
Syntax
APEX_PLUGIN_UTIL.GET_PLSQL_FUNC_RESULT_CLOB (
p_plsql_expression IN VARCHAR2 )
RETURN CLOB;
Parameters
Table 41-38 GET_PLSQL_FUNC_RESULT_CLOB Parameters
Parameter | Description |
---|---|
p_plsql_expression |
A PL/SQL function block that returns a result of type string. |
Table 41-39 Returns
Return | Description |
---|---|
CLOB |
String result value returned by the PL/SQL function block. |
Example
l_clob := apex_plugin_util.get_plsql_expr_result_clob (
p_plsql_function => p_item.attribute_03 );
Parent topic: APEX_PLUGIN_UTIL