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

INSERT_CHECKSUM

DDL script

Arguments:

NameData TypeDefault ValueIn/Out
CHECKSUM_INVARCHAR2 IN
CHECKSUM_TYPE_INVARCHAR2 IN

Returns:

NUMBER(38)

Source

Legend: comment string keyword reserved word operator
     1: function insert_checksum(checksum_in in varchar2, checksum_type_in in varchar2)
     2: return number
     3: is
     4:     checksum_id number;
     5:     pragma autonomous_transaction;
     6: begin
     7:     insert into rhnChecksum (id, checksum_type_id, checksum)
     8:     values (rhnChecksum_seq.nextval,
     9:             (select id from rhnChecksumType where label = checksum_type_in),
    10:              checksum_in) returning id into checksum_id;
    11:     commit;
    12:     return checksum_id;
    13: end;