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

INSERT_TRANSACTION_PACKAGE

DDL script

Arguments:

NameData TypeDefault ValueIn/Out
O_IDNUMBER(38) IN
N_IDNUMBER(38) IN
E_IDNUMBER(38) IN
P_ARCH_IDNUMBER(38) IN

Returns:

NUMBER(38)

Source

Legend: comment string keyword reserved word operator
     1: function insert_transaction_package(
     2:     o_id in number,
     3:     n_id in number,
     4:     e_id in number,
     5:     p_arch_id in number)
     6: return number
     7: is
     8:     pragma autonomous_transaction;
     9:     tp_id   number;
    10: begin
    11:     insert into rhnTransactionPackage (id, operation, name_id, evr_id, package_arch_id)
    12:     values (rhn_transpack_id_seq.nextval, o_id, n_id, e_id, p_arch_id) returning id into tp_id;
    13:     commit;
    14:     return tp_id;
    15: end;