GET_PLSQL_FUNCTION_RESULT Function

This function executes a PL/SQL function block and returns the 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_FUNCTION_RESULT (
    p_plsql_function IN VARCHAR2)
RETURN VARCHAR2;

Parameters

Table 19-24 describes the parameters available in the GET_PLSQL_FUNCTION_RESULT function.

---

Table 19-24 GET_PLSQL_FUNCTION_RESULT Parameters

Parameter	Description
p_plsql_function	A PL/SQL function block that returns a result of type string.

---

Return

Table 19-25 describes the return value by the function GET_PLSQL_FUNCTION_RESULT.

---

Table 19-25 GET_PLSQL_FUNCTION_RESULT Return

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

---

Example

The following example executes and returns the 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_function_result (
    p_plsql_function => p_item.attribute_03 );