INSERT_CHECKSUM
DDL scriptArguments:
Name | Data Type | Default Value | In/Out |
---|
CHECKSUM_IN | VARCHAR2 | | IN |
CHECKSUM_TYPE_IN | VARCHAR2 | | IN |
Returns:
NUMBER(38)Source
Legend: 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;