LOOKUP_PACKAGE_ARCH

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: FUNCTION
     2: LOOKUP_PACKAGE_ARCH(label_in IN VARCHAR2)
     3: RETURN NUMBER
     4: IS
     5: 	package_arch_id		NUMBER;
     6: BEGIN
     7:    if label_in is null then
     8:       return null;
     9:    end if;
    10: 
    11: 	SELECT id
    12:           INTO package_arch_id
    13:           FROM rhnPackageArch
    14:          WHERE label = label_in;
    15: 
    16: 	RETURN package_arch_id;
    17: EXCEPTION
    18:         WHEN NO_DATA_FOUND THEN
    19:             rhn_exception.raise_exception('package_arch_not_found');
    20: END;