Oracle | OWA

Oracle OWA_MATCH Version 23c

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