45.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_function  IN VARCHAR2,
    p_auto_bind_items IN BOOLEAN     DEFAULT TRUE,
    p_bind_list       IN t_bind_list DEFAULT c_empty_bind_list )
    RETURN CLOB;

Parameters

Parameter	Description
p_plsql_function	A PL/SQL function block that returns a result of type CLOB.
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.

Table 45-2 Returns

Return	Description
CLOB	CLOB result value returned by the PL/SQL function block.

Example

l_clob := apex_plugin_util.get_plsql_func_result_clob (
    p_plsql_function => p_item.attribute_03 );