LOOKUP_CONFIG_FILENAME

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: function
     2: lookup_config_filename(name_in in varchar2)
     3: return number
     4: is
     5:     pragma autonomous_transaction;
     6:     name_id		number;
     7: begin
     8:     select id
     9:       into name_id
    10:       from rhnConfigFileName
    11:      where path = name_in;
    12: 
    13:     return name_id;
    14: exception when no_data_found then
    15:     begin
    16:         select insert_config_filename(name_in) into name_id from dual;
    17:     exception when dup_val_on_index then
    18:         select id
    19:           into name_id
    20:           from rhnConfigFileName
    21:          where path = name_in;
    22:     end;
    23: 
    24: 	return name_id;
    25: end;