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

INSERT_PACKAGE_NEVRA

DDL script

Arguments:

NameData TypeDefault ValueIn/Out
NAME_ID_INVARCHAR2 IN
EVR_ID_INVARCHAR2 IN
PACKAGE_ARCH_ID_INVARCHAR2 IN

Returns:

NUMBER(38)

Source

Legend: comment string keyword reserved word operator
     1: function insert_package_nevra(
     2:     name_id_in in varchar2,
     3:     evr_id_in in varchar2,
     4:     package_arch_id_in in varchar2
     5: ) return number
     6: is
     7:     pragma autonomous_transaction;
     8:     nevra_id number;
     9: begin
    10:     insert into rhnPackageNEVRA(id, name_id, evr_id, package_arch_id) values
    11:         (rhn_pkgnevra_id_seq.nextval,
    12:          name_id_in,
    13:          evr_id_in,
    14:          package_arch_id_in) returning id into nevra_id;
    15:     commit;
    16:     return nevra_id;
    17: end;