General Information
Library Note
Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com . Request a Workshop for
your organization today.
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