Rem drv: <create type="types"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/latest/masking/dm_types.sql /st_emdbsa_11.2/1 2009/01/29 14:28:58 kmckeen Exp $
Rem
Rem cm_types.sql
Rem
Rem Copyright (c) 2002, 2009, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      dm_types - Data Masking Types
Rem
Rem    DESCRIPTION
Rem      DM Backend
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    xshen       09/20/06 - array list etc
Rem    lhan        04/02/06 - Created
Rem

-- DROP TYPE mgmt_dm_rule_sets;
-- DROP TYPE mgmt_dm_rule_entry;
-- DROP TYPE mgmt_dm_array_list;

CREATE OR REPLACE TYPE mgmt_dm_array_list AS TABLE OF VARCHAR2(128);
/

CREATE OR REPLACE TYPE mgmt_dm_rule_entry AS OBJECT (
      rule_type    VARCHAR2(30), 
      rule_option  VARCHAR2(2),
      rule_low     NUMBER,
      rule_high    NUMBER,
      start_date   DATE,
      end_date     DATE,
      fixed_string VARCHAR2(30), 
      fixed_number NUMBER,
      table_schema VARCHAR2(30),
      table_name   VARCHAR2(30),
      column_name  VARCHAR2(30),
      udf_name     VARCHAR2(512),
      arr_list     mgmt_dm_array_list);
/ 

CREATE OR REPLACE TYPE mgmt_dm_rule_sets AS TABLE OF mgmt_dm_rule_entry;
/