LOOKUP_PACKAGE_NAME

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: function
     2: lookup_package_name(name_in in varchar2, ignore_null in number := 0)
     3: return number
     4: is
     5:     name_id		number;
     6: begin
     7:     if ignore_null = 1 and name_in is null then
     8:         return null;
     9:     end if;
    10: 
    11:     select id
    12:       into name_id
    13:       from rhnPackageName
    14:      where name = name_in;
    15: 
    16:     return name_id;
    17: exception when no_data_found then
    18:     begin
    19:         name_id := insert_package_name(name_in);
    20:     exception when dup_val_on_index then
    21:         select id
    22:           into name_id
    23:           from rhnPackageName
    24:          where name = name_in;
    25:     end;
    26:     return name_id;
    27: end;