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

DELETE_ERRATA

Arguments:

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

Source

Legend: comment string keyword reserved word operator
     1: procedure
     2: delete_errata (
     3: 	errata_id_in in number
     4: ) is
     5: begin
     6: 	delete from rhnServerNeededCache where errata_id = errata_id_in;
     7: 	delete from rhnErrataFile where errata_id = errata_id_in;
     8: 	delete from rhnErrataPackage where errata_id = errata_id_in;
     9: 	delete from rhnErrata where id = errata_id_in;
    10: 	delete from rhnErrataTmp where id = errata_id_in;
    11: end delete_errata;