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

INSERT_EVR

DDL script

Arguments:

NameData TypeDefault ValueIn/Out
E_INVARCHAR2 IN
V_INVARCHAR2 IN
R_INVARCHAR2 IN

Returns:

NUMBER(38)

Source

Legend: comment string keyword reserved word operator
     1: function insert_evr(e_in in varchar2, v_in in varchar2, r_in in varchar2)
     2: return number
     3: is
     4:     pragma autonomous_transaction;
     5:     evr_id  number;
     6: begin
     7:     insert into rhnPackageEVR(id, epoch, version, release, evr)
     8:     values (rhn_pkg_evr_seq.nextval,
     9:             e_in,
    10:             v_in,
    11:             r_in,
    12:             evr_t(e_in, v_in, r_in)) returning id into evr_id;
    13:     commit;
    14:     return evr_id;
    15: end;