37.30 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 37-44 GET_SEARCH_STRING Parameters
Parameter | Description |
---|---|
|
Type of search when used with |
|
Search string used for the search with |
Return
Table 37-45 GET_SEARCH_STRING Return
Return | Description |
---|---|
|
Returns |
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 ) );
Parent topic: APEX_PLUGIN_UTIL