RHN_CONTACT_METHODS

Description:

cmeth contact method definitions

Columns

Primary key:

Check Constraints:

Foreign Keys:

Options:

Indexes:

Referenced by:

Triggers

RHN_CMETH_VAL_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_cmeth_val_trig
before insert or update on rhn_contact_methods
referencing new as new old as old
for each row

REFERENCING NEW AS NEW OLD AS OLD
declare
    msg  varchar2(200);
    missing_data exception;
begin
    msg :='missing or invalid data for contact_methods table';
    if :new.method_type_id = 1
    then
        if (
            :new.pager_email   is null     or
            :new.pager_split_long_messages  is null )
        then
            raise missing_data;
        end if;
    end if;
    if :new.method_type_id = 2
    then
        if :new.email_address is null
        then
            raise missing_data;
        end if;
    end if;
    if :new.method_type_id = 5
    then
        if (:new.snmp_host is null   or
           :new.snmp_port is null)
        then
            raise missing_data;
        end if;
    end if;
    exception
    when missing_data then
    raise_application_error (-20012,msg);
    when others then
    raise;
end;