14:
15: function match_pattern
16: (
17: p_string in varchar2,
18: p_simple_pattern in owa_util.vc_arr default empty_vc_arr,
19: p_complex_pattern in owa_util.vc_arr default empty_vc_arr,
20: p_use_special_chars in boolean default true
21: )
22: return boolean is
15: function match_pattern
16: (
17: p_string in varchar2,
18: p_simple_pattern in owa_util.vc_arr default empty_vc_arr,
19: p_complex_pattern in owa_util.vc_arr default empty_vc_arr,
20: p_use_special_chars in boolean default true
21: )
22: return boolean is
23: l_string varchar2(512) := upper(p_string);