GET_PLSQL_EXPRESSION_RESULT Function

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

Parameters

Table: GET_PLSQL_EXPRESSION_RESULT Parameters describes the parameters available in the GET_PLSQL_EXPRESSION_RESULT function.

GET_PLSQL_EXPRESSION_RESULT Parameters

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

Return

Table: GET_PLSQL_EXPRESSION_RESULT Return describes the return value by the function GET_PLSQL_EXPRESSION_RESULT.

GET_PLSQL_EXPRESSION_RESULT Return

Return	Description
`VARCHAR2`	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_expression_result (
    p_plsql_expression => p_item.attribute_03 );