GET_PLSQL_FUNC_RESULT_BOOLEAN Function

45.27 GET_PLSQL_FUNC_RESULT_BOOLEAN Function

This function executes a PL/SQL function block and returns the Boolean result. This function also performs 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_BOOLEAN (
    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 BOOLEAN;

Parameters

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

Return

Return	Description
`BOOLEAN`	Boolean result value returned by the PL/SQL function block.

Example

The following example executes and returns the Boolean result of the PL/SQL function body that is specified in attribute_03 of an item type plug-in attribute of type PL/SQL Function Body.

l_result := apex_plugin_util.get_plsql_func_result_boolean (
    p_plsql_function => p_item.attribute_03 );

Parent topic: APEX_PLUGIN_UTIL