LOOKUP_TAG

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: FUNCTION
     2: LOOKUP_TAG(org_id_in IN NUMBER, name_in IN VARCHAR2)
     3: RETURN NUMBER
     4: DETERMINISTIC
     5: IS
     6: 	PRAGMA AUTONOMOUS_TRANSACTION;
     7: 	tag_id     NUMBER;
     8: BEGIN
     9:         select id into tag_id
    10: 	  from rhnTag
    11: 	 where org_id = org_id_in
    12: 	   and name_id = lookup_tag_name(name_in);
    13:         RETURN tag_id;
    14: EXCEPTION
    15:         WHEN NO_DATA_FOUND THEN
    16:             insert into rhnTag(id, org_id, name_id)
    17:                     values (rhn_tag_id_seq.nextval, org_id_in, lookup_tag_name(name_in))
    18:                     returning id into tag_id;
    19:             COMMIT;
    20:             RETURN tag_id;
    21: END;