ACS3 Data Model

     1: FUNCTION guess_user_email_type (v_email varchar)
     2: RETURN varchar
     3: IS
     4: cursor mail_cursor is select * from default_email_types;
     5: BEGIN
     6:   FOR mail_val IN mail_cursor LOOP
     7:     IF upper(v_email) LIKE upper(mail_val.pattern)  THEN
     8: 	    RETURN mail_val.mail_type;
     9:     END IF;
    10:   END LOOP;
    11: -- default
    12:   RETURN 'text/html';
    13: END guess_user_email_type;