LOOKUP_CHANNEL_ARCH

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: FUNCTION
     2: LOOKUP_CHANNEL_ARCH(label_in IN VARCHAR2)
     3: RETURN NUMBER
     4: DETERMINISTIC
     5: IS
     6: 	channel_arch_id		NUMBER;
     7: BEGIN
     8: 	SELECT id
     9:           INTO channel_arch_id
    10:           FROM rhnChannelArch
    11:          WHERE label = label_in;
    12: 	RETURN channel_arch_id;
    13: EXCEPTION
    14:         WHEN NO_DATA_FOUND THEN
    15:             rhn_exception.raise_exception('channel_arch_not_found');
    16: END;