41.24 GET_PLSQL_EXPR_RESULT_BOOLEAN Function
This function executes a PL/SQL expression and returns a Boolean result. This function also performs the binding of any bind variables in the provided PL/SQL expression. This function is usually used for plug-in attributes of type PL/SQL expression.
Syntax
APEX_PLUGIN_UTIL.GET_PLSQL_EXPR_RESULT_BOOLEAN (
p_plsql_expression IN BOOLEAN )
RETURN VARCHAR2;
Parameters
Table 41-30 GET_PLSQL_EXPR_RESULT_BOOLEAN Parameters
Parameter | Description |
---|---|
p_plsql_expression_result |
A PL/SQL expression that returns a string. |
Return
Table 41-31 GET_PLSQL_EXPR_RESULT_BOOLEAN Returns
Return | Description |
---|---|
BOOLEAN |
String result value returned by the PL/SQL expression. |
Example
This example executes and returns the result of the PL/SQL expression which is specified in attribute_03
of an item type plug-in attribute of type PL/SQL Expression
.
l_result := apex_plugin_util.get_plsql_expr_result_boolean (
p_plsql_expression => p_item.attribute_03 );
Parent topic: APEX_PLUGIN_UTIL