| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
for use with the Oracle Web Agent |
| AUTHID |
DEFINER |
| Data Types |
empty_vc_arr owa_util.vc_arr; |
| Dependencies |
| OWA_PATTERN |
OWA_UTIL |
PLITBLM |
|
| Documented |
No |
| First Available |
2004 |
| Security Model |
Owned by SYS with EXECUTE granted to PUBLIC |
| Source |
{ORACLE_HOME}/rdbms/admin/pubmat.sql
{ORACLE_HOME}/rdbms/admin/privmat.sql |
| |
| MATCH_PATTERN |
| Pattern matches against |
owa_match.match_pattern(
p_string IN VARCHAR2,
p_simple_pattern IN owa_util.vc_arr DEFAULT empty_vc_arr,
p_complex_pattern IN owa_util.vc_arr DEFAULT empty_vc_arr,
p_use_special_chars IN BOOLEAN DEFAULT TRUE)
RETURN BOOLEAN; |
DECLARE
sPattern owa_util.vc_arr;
cPattern owa_util.vc_arr;
BEGIN
sPattern(1) := 'sys.%';
sPattern(2) := 'dbms\_%';
sPattern(3) := 'utl\_%';
sPattern(4) := 'owa\_%';
sPattern(5) := 'owa.%';
sPattern(6) := 'htp.%';
sPattern(7) := 'htf.%';
IF ((owa_match.match_pattern('test', sPattern, cPattern, TRUE))) THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
IF ((owa_match.match_pattern('sys.%', sPattern, cPattern, TRUE))) THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/
F
T |