Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips
Arguments Source

INSERT_TAG

DDL script

Arguments:

NameData TypeDefault ValueIn/Out
ORG_ID_INNUMBER(38) IN
NAME_INVARCHAR2 IN

Returns:

NUMBER(38)

Source

Legend: comment string keyword reserved word operator
     1: function insert_tag(org_id_in in number, name_in in varchar2)
     2: return number
     3: is
     4:     pragma autonomous_transaction;
     5:     tag_id  number;
     6: begin
     7:     insert into rhnTag(id, org_id, name_id)
     8:     values (rhn_tag_id_seq.nextval, org_id_in, lookup_tag_name(name_in)) returning id into tag_id;
     9:     commit;
    10:     return tag_id;
    11: end;