21.21 GET_SEARCH_STRING Function

Based on the provided value in p_search_type the passed in value of p_search_string is returned unchanged or is converted to uppercase. Use this function with the p_search_string parameter of get_data and get_data2.

Syntax

APEX_PLUGIN_UTIL.GET_SEARCH_STRING(
    p_search_type IN VARCHAR2,
    p_search_string IN VARCHAR2)
RETURN VARCHAR2;

Parameters

Table 21-29 GET_SEARCH_STRING Parameters

Parameter	Description
`p_search_type`	Type of search when used with `get_data` and `get_data2`. Use one of the `c_search_*` constants.
`p_search_string`	Search string used for the search with `get_data` and `get_data2`.

Return

Table 21-30 GET_SEARCH_STRING Return

Return	Description
`VARCHAR2`	Returns `p_search_string` unchanged or in uppercase if `p_search_type` is of type `c_search_contains_ignore` or `c_search_exact_ignore`.

Example

This example uses a call to get_data or get_data2 to make sure the search string is using the correct case.

l_column_value_list :=
    apex_plugin_util.get_data (
        p_sql_statement    => p_item.lov_definition,
        p_min_columns      => 2,
        p_max_columns      => 2,
        p_component_name   => p_item.name,
        p_search_type      => apex_plugin_util.c_search_contains_ignore,
        p_search_column_no => 1,
        p_search_string    => apex_plugin_util.get_search_string (
            p_search_type   => apex_plugin_util.c_search_contains_ignore,
            p_search_string => p_value ) );