LOOKUP_TAG_NAME

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

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