QUEUE_SERVER

Arguments:

Source

Legend: comment string keyword reserved word operator

     1: PROCEDURE
     2: queue_server(server_id_in IN NUMBER, immediate_in IN NUMBER := 1)
     3: IS
     4:     org_id_tmp NUMBER;
     5: BEGIN
     6:     IF immediate_in > 0
     7:     THEN
     8:         DELETE FROM rhnServerNeededCache WHERE server_id = server_id_in;
     9:         INSERT INTO rhnServerNeededCache
    10:        	    (SELECT server_id, errata_id, package_id
    11: 	       FROM rhnServerNeededView
    12:               WHERE server_id = server_id_in);
    13: 
    14:     ELSE
    15:           SELECT org_id INTO org_id_tmp FROM rhnServer WHERE id = server_id_in;
    16: 
    17: 	  INSERT
    18:             INTO rhnTaskQueue
    19:                  (org_id, task_name, task_data)
    20:           VALUES (org_id_tmp,
    21:                   'update_server_errata_cache',
    22:                   server_id_in);
    23:     END IF;
    24: END queue_server;