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: IS
     5: 	PRAGMA AUTONOMOUS_TRANSACTION;
     6: 	source_id	NUMBER;
     7: BEGIN
     8:         select	id into source_id
     9:         from	rhnSourceRPM
    10:         where	name = name_in;
    11: 
    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;