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

DELETE_SERVER_BULK

Arguments:

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

Source

Legend: comment string keyword reserved word operator
     1: procedure delete_server_bulk (
     2: 	user_id_in in number
     3: ) is
     4: 	cursor systems is
     5: 		select	s.element id
     6: 		from	rhnSet s
     7: 		where	s.user_id = user_id_in
     8: 			and s.label = 'system_list';
     9: begin
    10: 	for s in systems loop
    11:                 delete_server(s.id);
    12: 	end loop;
    13: end delete_server_bulk;