RHN_INSTALL_ORG_SATELLITES
Arguments:
| Name | Data Type | Default Value | In/Out |
|---|
| FOR_CUSTOMER_ID | NUMBER(38) | | IN |
| SAT_CLUSTER_ID | NUMBER(12) | | IN |
| USERNAME | VARCHAR2(40) | | IN |
DDL scriptSource
Legend: string keyword reserved word operator
1: procedure
2: rhn_install_org_satellites
3: (
4: for_customer_id in web_customer.id%type,
5: sat_cluster_id in rhn_sat_cluster.recid%type,
6: username in rhn_command_queue_instances.last_update_user%type
7: )
8: is
9:
10:
11: cursor satellite_cursor is
12: select recid from rhn_sat_cluster
13: where customer_id = for_customer_id
14: and recid not in (
15: select netsaint_id from rhn_ll_netsaint
16: )
17: minus
18: select recid from rhn_sat_cluster
19: where customer_id = for_customer_id
20: and recid not in (sat_cluster_id);
21:
22: command_instance_id rhn_command_queue_instances.recid%type;
23:
24: begin
25: rhn_prepare_install(username, command_instance_id, 1);
26:
27: for satellite in satellite_cursor loop
28: rhn_install_satellite(command_instance_id, satellite.recid);
29: end loop;
30: end rhn_install_org_satellites;