37.24 GET_PLSQL_EXPR_RESULT_CLOB Function

This function executes a PL/SQL expression and returns a CLOB 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_CLOB (
    p_plsql_expression IN VARCHAR2 )
    RETURN CLOB;

Parameters

Table 37-32 GET_PLSQL_EXPR_RESULT_CLOB Parameters

Parameter	Description
p_plsql_expression	A PL/SQL expression that returns a string.

Table 37-33 Returns

Return	Description
CLOB	String result value returned by the PL/SQL expression.

Example

l_clob := apex_plugin_util.get_plsql_expr_result_clob (
              p_plsql_expression => p_item.attribute_03 );