LOOKUP_EVR

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: FUNCTION
     2: LOOKUP_EVR(e_in IN VARCHAR2, v_in IN VARCHAR2, r_in IN VARCHAR2)
     3: RETURN NUMBER
     4: DETERMINISTIC
     5: IS
     6: 	PRAGMA AUTONOMOUS_TRANSACTION;
     7: 	evr_id		NUMBER;
     8: BEGIN
     9: 	SELECT id INTO evr_id
    10:           FROM rhnPackageEvr
    11:          WHERE ((epoch IS NULL and e_in IS NULL) OR (epoch = e_in))
    12:            AND version = v_in AND release = r_in;
    13: 	RETURN evr_id;
    14: EXCEPTION
    15:         WHEN NO_DATA_FOUND THEN
    16:             INSERT INTO rhnPackageEvr (id, epoch, version, release, evr)
    17:             VALUES (rhn_pkg_evr_seq.nextval, e_in, v_in, r_in,
    18:                 EVR_T(e_in, v_in, r_in))
    19:             RETURNING id INTO evr_id;
    20:         COMMIT;
    21: 	RETURN evr_id;
    22: END;