LOOKUP_SOURCE_NAME

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: FUNCTION
     2: LOOKUP_SOURCE_NAME(name_in IN VARCHAR2)
     3: RETURN NUMBER
     4: DETERMINISTIC
     5: IS
     6: 	PRAGMA AUTONOMOUS_TRANSACTION;
     7: 	source_id	NUMBER;
     8: BEGIN
     9:         select	id into source_id
    10:         from	rhnSourceRPM
    11:         where	name = name_in;
    12:         RETURN source_id;
    13: EXCEPTION
    14:         WHEN NO_DATA_FOUND THEN
    15:             insert into rhnSourceRPM(id, name)
    16:                     values (rhn_sourcerpm_id_seq.nextval, name_in)
    17:                     returning id into source_id;
    18:             COMMIT;
    19:             RETURN source_id;
    20: END;