INSERT_TRANSACTION_PACKAGE
DDL scriptArguments:
Name | Data Type | Default Value | In/Out |
---|
O_ID | NUMBER(38) | | IN |
N_ID | NUMBER(38) | | IN |
E_ID | NUMBER(38) | | IN |
P_ARCH_ID | NUMBER(38) | | IN |
Returns:
NUMBER(38)Source
Legend: 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;