DROP TYPE PATS.ID_LIST;

CREATE OR REPLACE TYPE PATS."ID_LIST"                                          AS VARRAY (200)
    OF INT
/


GRANT EXECUTE ON PATS.ID_LIST TO PATSHOST_ROLE;
DROP TYPE PATS.LONG_STRING_LIST;

CREATE OR REPLACE TYPE PATS."LONG_STRING_LIST"                                          AS VARRAY (20) OF VARCHAR2(4000)
/


GRANT EXECUTE ON PATS.LONG_STRING_LIST TO PATSHOST_ROLE;
DROP TYPE PATS.NOTIFICATION_DETAIL_OBJECT;

CREATE OR REPLACE TYPE PATS."NOTIFICATION_DETAIL_OBJECT"                                          AS OBJECT
  (employee_notified_id INT(10)
  , querystring VARCHAR2(50)
  , message VARCHAR2(4000));
/
DROP TYPE PATS.STRING_LIST;

CREATE OR REPLACE TYPE PATS."STRING_LIST"                                          AS VARRAY (2050) OF VARCHAR2(1000)
/


GRANT EXECUTE ON PATS.STRING_LIST TO PATSHOST_ROLE;
