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: is
     5:     evr_id  number;
     6: begin
     7:     select id
     8:       into evr_id
     9:       from rhnPackageEVR
    10:     where ((epoch is null and e_in is null) or (epoch = e_in)) and
    11:           version = v_in and
    12:           release = r_in;
    13: 
    14:     return evr_id;
    15: exception when no_data_found then
    16:     begin
    17:         evr_id := insert_evr(e_in, v_in, r_in);
    18:     exception when dup_val_on_index then
    19:         select id
    20:           into evr_id
    21:           from rhnPackageEVR
    22:         where ((epoch is null and e_in is null) or (epoch = e_in)) and
    23:               version = v_in and
    24:               release = r_in;
    25:     end;
    26: 
    27: 	return evr_id;
    28: end;