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

QUEUE_ERRATA

Arguments:

NameData TypeDefault ValueIn/Out
ERRATA_ID_INNUMBER(38) IN
DDL script

Source

Legend: comment string keyword reserved word operator
     1: PROCEDURE
     2: queue_errata(errata_id_in IN NUMBER)
     3: IS
     4: BEGIN
     5: 	INSERT INTO rhnSNPErrataQueue (errata_id) VALUES (errata_id_in);
     6: EXCEPTION
     7: 	WHEN DUP_VAL_ON_INDEX THEN
     8: 	     UPDATE rhnSNPErrataQueue SET processed = 0 WHERE errata_id = errata_id_in;
     9: END;