LOOKUP_CONFIG_INFO

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: function
     2: lookup_config_info (
     3:     username_in     in varchar2,
     4:     groupname_in    in varchar2,
     5:     filemode_in     in varchar2
     6: ) return number
     7: deterministic
     8: is
     9:     pragma autonomous_transaction;
    10:     v_id    number;
    11:     cursor lookup_cursor is
    12:         select id
    13:           from rhnConfigInfo
    14:          where 1=1
    15:            and username = username_in
    16:            and groupname = groupname_in
    17:            and filemode = filemode_in;
    18: begin
    19:     for r in lookup_cursor loop
    20:         return r.id;
    21:     end loop;
    22:     select rhn_confinfo_id_seq.nextval
    23:       into v_id
    24:       from dual;
    25:     insert into rhnConfigInfo (id, username, groupname, filemode)
    26:     values (v_id, username_in, groupname_in, filemode_in);
    27:     commit;
    28:     return v_id;
    29: end lookup_config_info;